/*
 Navicat Premium Data Transfer

 Source Server         : SEI_SERVER
 Source Server Type    : SQL Server
 Source Server Version : 13004001
 Source Host           : 10.1.2.34:1433
 Source Catalog        : jack_qc_system
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 13004001
 File Encoding         : 65001

 Date: 12/10/2024 14:53:58
*/


-- ----------------------------
-- Table structure for gen_table
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[gen_table]') AND type IN ('U'))
	DROP TABLE [dbo].[gen_table]
GO

CREATE TABLE [dbo].[gen_table] (
  [table_id] bigint  IDENTITY(1,1) NOT NULL,
  [table_name] nvarchar(200) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [table_comment] nvarchar(500) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [sub_table_name] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [sub_table_fk_name] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [class_name] nvarchar(100) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [tpl_category] nvarchar(200) COLLATE Latin1_General_BIN DEFAULT (N'crud') NULL,
  [tpl_web_type] nvarchar(30) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [package_name] nvarchar(100) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [module_name] nvarchar(30) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [business_name] nvarchar(30) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [function_name] nvarchar(50) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [function_author] nvarchar(50) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [gen_type] nchar(1) COLLATE Latin1_General_BIN DEFAULT (N'0') NULL,
  [gen_path] nvarchar(200) COLLATE Latin1_General_BIN DEFAULT (N'/') NULL,
  [options] nvarchar(1000) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [create_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [create_time] datetime2(0) DEFAULT NULL NULL,
  [update_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [update_time] datetime2(0) DEFAULT NULL NULL,
  [remark] nvarchar(500) COLLATE Latin1_General_BIN DEFAULT NULL NULL
)
GO

ALTER TABLE [dbo].[gen_table] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of gen_table
-- ----------------------------
SET IDENTITY_INSERT [dbo].[gen_table] ON
GO

INSERT INTO [dbo].[gen_table] ([table_id], [table_name], [table_comment], [sub_table_name], [sub_table_fk_name], [class_name], [tpl_category], [tpl_web_type], [package_name], [module_name], [business_name], [function_name], [function_author], [gen_type], [gen_path], [options], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'4', N'sys_config', N'dbo.sys_config', NULL, NULL, N'SysConfig', N'crud', N'', N'com.jack.system', N'system', N'config', N'dbo.sys_config', N'ruoyi', N'0', N'/', NULL, N'admin', N'2024-08-14 14:30:55', N'', NULL, NULL)
GO

INSERT INTO [dbo].[gen_table] ([table_id], [table_name], [table_comment], [sub_table_name], [sub_table_fk_name], [class_name], [tpl_category], [tpl_web_type], [package_name], [module_name], [business_name], [function_name], [function_author], [gen_type], [gen_path], [options], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'5', N'tb_user', N'table test', NULL, NULL, N'TbUser', N'crud', N'element-plus', N'com.jack.system', N'system', N'user', N'table test', N'ruoyi', N'0', N'/', N'{"parentMenuId":""}', N'admin', N'2024-08-14 14:59:38', N'', N'2024-08-28 16:15:55', NULL)
GO

INSERT INTO [dbo].[gen_table] ([table_id], [table_name], [table_comment], [sub_table_name], [sub_table_fk_name], [class_name], [tpl_category], [tpl_web_type], [package_name], [module_name], [business_name], [function_name], [function_author], [gen_type], [gen_path], [options], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'6', N'tb_fe_menu', N'Factory Evaluation Menu Item', N'', N'', N'FeMenu', N'tree', N'element-plus', N'com.jack.qcfe', N'fe', N'menu', N'Factory Evaluation Menu', N'Jack Cheng', N'0', N'/', N'{"treeCode":"menu_id","treeName":"menu_name_en","treeParentCode":"menu_parent_id","parentMenuId":""}', N'admin', N'2024-08-28 10:26:47', N'', N'2024-08-28 12:10:05', NULL)
GO

INSERT INTO [dbo].[gen_table] ([table_id], [table_name], [table_comment], [sub_table_name], [sub_table_fk_name], [class_name], [tpl_category], [tpl_web_type], [package_name], [module_name], [business_name], [function_name], [function_author], [gen_type], [gen_path], [options], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'7', N'tb_femenu', N'Factory Evaluation Menu', N'', N'', N'Femenu', N'tree', N'element-plus', N'com.jack.qcfe', N'fe', N'femenu', N'Factory Evaluation Menu', N'Jack Cheng', N'0', N'/', N'{"treeCode":"menu_id","treeName":"menu_name_en","treeParentCode":"menu_parent_id","parentMenuId":""}', N'admin', N'2024-08-28 16:44:39', N'', N'2024-08-28 16:50:16', NULL)
GO

SET IDENTITY_INSERT [dbo].[gen_table] OFF
GO


-- ----------------------------
-- Table structure for gen_table_column
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[gen_table_column]') AND type IN ('U'))
	DROP TABLE [dbo].[gen_table_column]
GO

CREATE TABLE [dbo].[gen_table_column] (
  [column_id] bigint  IDENTITY(1,1) NOT NULL,
  [table_id] bigint DEFAULT NULL NULL,
  [column_name] nvarchar(200) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [column_comment] nvarchar(500) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [column_type] nvarchar(100) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [java_type] nvarchar(500) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [java_field] nvarchar(200) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [is_pk] nchar(1) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [is_increment] nchar(1) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [is_required] nchar(1) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [is_insert] nchar(1) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [is_edit] nchar(1) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [is_list] nchar(1) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [is_query] nchar(1) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [query_type] nvarchar(200) COLLATE Latin1_General_BIN DEFAULT (N'EQ') NULL,
  [html_type] nvarchar(200) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [dict_type] nvarchar(200) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [sort] int DEFAULT NULL NULL,
  [create_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [create_time] datetime2(0) DEFAULT NULL NULL,
  [update_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [update_time] datetime2(0) DEFAULT NULL NULL
)
GO

ALTER TABLE [dbo].[gen_table_column] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of gen_table_column
-- ----------------------------
SET IDENTITY_INSERT [dbo].[gen_table_column] ON
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1', N'4', N'config_id', N' ', N'int', N'Long', N'configId', N'1', N'1', N'1', N'1', NULL, NULL, NULL, N'EQ', N'input', N'', N'1', N'admin', N'2024-08-14 14:30:55', N'', NULL)
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'2', N'4', N'config_name', N' ', N'nvarchar', N'String', N'configName', N'0', N'0', N'0', N'1', N'1', N'1', N'1', N'LIKE', N'input', N'', N'2', N'admin', N'2024-08-14 14:30:55', N'', NULL)
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'3', N'4', N'config_key', N' ', N'nvarchar', N'String', N'configKey', N'0', N'0', N'0', N'1', N'1', N'1', N'1', N'EQ', N'input', N'', N'3', N'admin', N'2024-08-14 14:30:55', N'', NULL)
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'4', N'4', N'config_value', N' ', N'nvarchar', N'String', N'configValue', N'0', N'0', N'0', N'1', N'1', N'1', N'1', N'EQ', N'input', N'', N'4', N'admin', N'2024-08-14 14:30:55', N'', NULL)
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'5', N'4', N'config_type', N' ', N'nchar', N'String', N'configType', N'0', N'0', N'0', N'1', N'1', N'1', N'1', N'EQ', N'select', N'', N'5', N'admin', N'2024-08-14 14:30:55', N'', NULL)
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'6', N'4', N'create_by', N' ', N'nvarchar', N'String', N'createBy', N'0', N'0', N'0', N'1', NULL, NULL, NULL, N'EQ', N'input', N'', N'6', N'admin', N'2024-08-14 14:30:55', N'', NULL)
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'7', N'4', N'create_time', N' ', N'datetime2', N'String', N'createTime', N'0', N'0', N'0', N'1', NULL, NULL, NULL, N'EQ', NULL, N'', N'7', N'admin', N'2024-08-14 14:30:55', N'', NULL)
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'8', N'4', N'update_by', N' ', N'nvarchar', N'String', N'updateBy', N'0', N'0', N'0', N'1', N'1', NULL, NULL, N'EQ', N'input', N'', N'8', N'admin', N'2024-08-14 14:30:55', N'', NULL)
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'9', N'4', N'update_time', N' ', N'datetime2', N'String', N'updateTime', N'0', N'0', N'0', N'1', N'1', NULL, NULL, N'EQ', NULL, N'', N'9', N'admin', N'2024-08-14 14:30:55', N'', NULL)
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'10', N'4', N'remark', N' ', N'nvarchar', N'String', N'remark', N'0', N'0', N'0', N'1', N'1', N'1', NULL, N'EQ', N'input', N'', N'10', N'admin', N'2024-08-14 14:30:55', N'', NULL)
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'11', N'5', N'id', N'user id', N'int', N'Long', N'id', N'1', N'1', N'1', N'1', NULL, NULL, NULL, N'EQ', N'input', N'', N'1', N'admin', N'2024-08-14 14:59:38', N'', N'2024-08-28 16:15:55')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'12', N'5', N'name', N'user name', N'varchar', N'String', N'name', N'0', N'0', N'0', N'1', N'1', N'1', N'1', N'LIKE', N'input', N'', N'2', N'admin', N'2024-08-14 14:59:38', N'', N'2024-08-28 16:15:55')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'13', N'5', N'age', N'user age', N'int', N'Long', N'age', N'0', N'0', N'0', N'1', N'1', N'1', N'1', N'EQ', N'input', N'', N'3', N'admin', N'2024-08-14 14:59:38', N'', N'2024-08-28 16:15:55')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'14', N'6', N'menu_id', N'Menu Id', N'int', N'Long', N'menuId', N'0', N'1', N'0', N'0', N'0', N'0', N'0', N'EQ', N'input', N'', N'1', N'admin', N'2024-08-28 10:26:47', N'', N'2024-08-28 12:10:05')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'15', N'6', N'menu_type', N'Menu Type', N'int', N'Long', N'menuType', N'0', N'0', N'1', N'1', N'1', N'1', N'1', N'EQ', N'select', N'fe_menu_type', N'2', N'admin', N'2024-08-28 10:26:47', N'', N'2024-08-28 12:10:05')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'16', N'6', N'menu_name_en', N'Menu Name English', N'nvarchar', N'String', N'menuNameEn', N'0', N'0', N'1', N'1', N'1', N'1', N'1', N'EQ', N'input', N'', N'3', N'admin', N'2024-08-28 10:26:47', N'', N'2024-08-28 12:10:05')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'17', N'6', N'menu_name_zh', N'Menu Name Chinese', N'nvarchar', N'String', N'menuNameZh', N'0', N'0', N'1', N'1', N'1', N'1', N'0', N'EQ', N'input', N'', N'4', N'admin', N'2024-08-28 10:26:47', N'', N'2024-08-28 12:10:05')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'18', N'6', N'menu_parent_id', N'Menu Parent ID', N'int', N'Long', N'menuParentId', N'0', N'0', N'1', N'1', N'1', N'1', N'0', N'EQ', N'input', N'', N'5', N'admin', N'2024-08-28 10:26:47', N'', N'2024-08-28 12:10:05')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'19', N'6', N'menu_display_order', N'Menu Display Order', N'int', N'Long', N'menuDisplayOrder', N'0', N'0', N'1', N'1', N'1', N'1', N'0', N'EQ', N'input', N'', N'6', N'admin', N'2024-08-28 10:26:47', N'', N'2024-08-28 12:10:05')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'20', N'6', N'menu_rate', N'Menu Rate', N'int', N'Long', N'menuRate', N'0', N'0', N'0', N'1', N'1', N'1', N'0', N'EQ', N'input', N'', N'7', N'admin', N'2024-08-28 10:26:47', N'', N'2024-08-28 12:10:05')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'21', N'6', N'menu_status', N'Menu Status', N'int', N'Long', N'menuStatus', N'0', N'0', N'1', N'1', N'1', N'1', N'0', N'EQ', N'select', N'fe_status', N'8', N'admin', N'2024-08-28 10:26:47', N'', N'2024-08-28 12:10:05')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'22', N'6', N'menu_deleted', N'Menu Delete Flag', N'int', N'Long', N'menuDeleted', N'0', N'0', N'0', N'0', N'0', N'0', N'0', N'EQ', N'input', N'', N'9', N'admin', N'2024-08-28 10:26:47', N'', N'2024-08-28 12:10:05')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'23', N'6', N'create_time', N'Menu Create Time', N'datetime', N'Date', N'createTime', N'0', N'0', N'0', N'0', NULL, NULL, NULL, N'EQ', N'datetime', N'', N'10', N'admin', N'2024-08-28 10:26:47', N'', N'2024-08-28 12:10:05')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'24', N'6', N'update_time', N'Menu Update Time', N'datetime', N'Date', N'updateTime', N'0', N'0', N'0', N'0', N'0', NULL, NULL, N'EQ', N'datetime', N'', N'11', N'admin', N'2024-08-28 10:26:47', N'', N'2024-08-28 12:10:05')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'25', N'6', N'create_by', N'Menu Creator', N'nvarchar', N'String', N'createBy', N'0', N'0', N'0', N'0', NULL, NULL, NULL, N'EQ', N'input', N'', N'12', N'admin', N'2024-08-28 10:26:47', N'', N'2024-08-28 12:10:05')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'26', N'6', N'update_by', N'Menu Updator', N'nvarchar', N'String', N'updateBy', N'0', N'0', N'0', N'0', N'0', NULL, NULL, N'EQ', N'input', N'', N'13', N'admin', N'2024-08-28 10:26:47', N'', N'2024-08-28 12:10:05')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'27', N'6', N'menu_remark', N'Menu Remark', N'nvarchar', N'String', N'menuRemark', N'0', N'0', N'0', N'1', N'1', N'0', N'0', N'EQ', N'input', N'', N'14', N'admin', N'2024-08-28 10:26:47', N'', N'2024-08-28 12:10:05')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'28', N'7', N'menu_id', N'Menu Id', N'int', N'Long', N'menuId', N'0', N'1', N'0', N'0', N'0', N'0', N'0', N'EQ', N'input', N'', N'1', N'admin', N'2024-08-28 16:44:39', N'', N'2024-08-28 16:50:16')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'29', N'7', N'menu_type', N'Menu Type', N'int', N'Long', N'menuType', N'0', N'0', N'1', N'1', N'1', N'1', N'1', N'EQ', N'select', N'fe_menu_type', N'2', N'admin', N'2024-08-28 16:44:39', N'', N'2024-08-28 16:50:16')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'30', N'7', N'menu_name_en', N'Menu Name English', N'nvarchar', N'String', N'menuNameEn', N'0', N'0', N'1', N'1', N'1', N'1', N'1', N'EQ', N'input', N'', N'3', N'admin', N'2024-08-28 16:44:39', N'', N'2024-08-28 16:50:16')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'31', N'7', N'menu_name_zh', N'Menu Name Chinese', N'nvarchar', N'String', N'menuNameZh', N'0', N'0', N'1', N'1', N'1', N'1', N'0', N'EQ', N'input', N'', N'4', N'admin', N'2024-08-28 16:44:39', N'', N'2024-08-28 16:50:16')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'32', N'7', N'menu_parent_id', N'Menu Parent Id', N'int', N'Long', N'menuParentId', N'0', N'0', N'1', N'1', N'1', N'1', N'0', N'EQ', N'input', N'', N'5', N'admin', N'2024-08-28 16:44:39', N'', N'2024-08-28 16:50:16')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'33', N'7', N'menu_display_order', N'Menu Display Order', N'int', N'Long', N'menuDisplayOrder', N'0', N'0', N'1', N'1', N'1', N'1', N'0', N'EQ', N'input', N'', N'6', N'admin', N'2024-08-28 16:44:39', N'', N'2024-08-28 16:50:16')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'34', N'7', N'menu_rate', N'Menu Rate', N'int', N'Long', N'menuRate', N'0', N'0', N'0', N'1', N'1', N'1', N'0', N'EQ', N'input', N'', N'7', N'admin', N'2024-08-28 16:44:39', N'', N'2024-08-28 16:50:16')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'35', N'7', N'menu_status', N'Menu Status', N'int', N'Long', N'menuStatus', N'0', N'0', N'1', N'1', N'1', N'1', N'0', N'EQ', N'radio', N'fe_status', N'8', N'admin', N'2024-08-28 16:44:39', N'', N'2024-08-28 16:50:16')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'36', N'7', N'menu_deleted', N'Menu Deleted', N'int', N'Long', N'menuDeleted', N'0', N'0', N'1', N'1', N'0', N'0', N'0', N'EQ', N'input', N'', N'9', N'admin', N'2024-08-28 16:44:39', N'', N'2024-08-28 16:50:16')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'37', N'7', N'create_time', N'Menu Create Time', N'datetime', N'Date', N'createTime', N'0', N'0', N'0', N'1', NULL, NULL, NULL, N'EQ', N'datetime', N'', N'10', N'admin', N'2024-08-28 16:44:39', N'', N'2024-08-28 16:50:16')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'38', N'7', N'update_time', N'Menu Update Time', N'datetime', N'Date', N'updateTime', N'0', N'0', N'0', N'1', N'0', NULL, NULL, N'EQ', N'datetime', N'', N'11', N'admin', N'2024-08-28 16:44:39', N'', N'2024-08-28 16:50:16')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'39', N'7', N'create_by', N'Menu Create By', N'nvarchar', N'String', N'createBy', N'0', N'0', N'0', N'1', NULL, NULL, NULL, N'EQ', N'input', N'', N'12', N'admin', N'2024-08-28 16:44:39', N'', N'2024-08-28 16:50:16')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'40', N'7', N'update_by', N'Menu Update By', N'nvarchar', N'String', N'updateBy', N'0', N'0', N'0', N'1', N'0', NULL, NULL, N'EQ', N'input', N'', N'13', N'admin', N'2024-08-28 16:44:39', N'', N'2024-08-28 16:50:16')
GO

INSERT INTO [dbo].[gen_table_column] ([column_id], [table_id], [column_name], [column_comment], [column_type], [java_type], [java_field], [is_pk], [is_increment], [is_required], [is_insert], [is_edit], [is_list], [is_query], [query_type], [html_type], [dict_type], [sort], [create_by], [create_time], [update_by], [update_time]) VALUES (N'41', N'7', N'menu_remark', N'Menu Remark', N'nvarchar', N'String', N'menuRemark', N'0', N'0', N'0', N'1', N'1', N'1', N'1', N'EQ', N'input', N'', N'14', N'admin', N'2024-08-28 16:44:39', N'', N'2024-08-28 16:50:16')
GO

SET IDENTITY_INSERT [dbo].[gen_table_column] OFF
GO


-- ----------------------------
-- Table structure for qrtz_blob_triggers
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_blob_triggers]') AND type IN ('U'))
	DROP TABLE [dbo].[qrtz_blob_triggers]
GO

CREATE TABLE [dbo].[qrtz_blob_triggers] (
  [sched_name] nvarchar(120) COLLATE Latin1_General_BIN  NOT NULL,
  [trigger_name] nvarchar(200) COLLATE Latin1_General_BIN  NOT NULL,
  [trigger_group] nvarchar(200) COLLATE Latin1_General_BIN  NOT NULL,
  [blob_data] varbinary(max)  NULL
)
GO

ALTER TABLE [dbo].[qrtz_blob_triggers] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of qrtz_blob_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_calendars
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_calendars]') AND type IN ('U'))
	DROP TABLE [dbo].[qrtz_calendars]
GO

CREATE TABLE [dbo].[qrtz_calendars] (
  [sched_name] nvarchar(120) COLLATE Latin1_General_BIN  NOT NULL,
  [calendar_name] nvarchar(200) COLLATE Latin1_General_BIN  NOT NULL,
  [calendar] varbinary(max)  NOT NULL
)
GO

ALTER TABLE [dbo].[qrtz_calendars] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of qrtz_calendars
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_cron_triggers
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_cron_triggers]') AND type IN ('U'))
	DROP TABLE [dbo].[qrtz_cron_triggers]
GO

CREATE TABLE [dbo].[qrtz_cron_triggers] (
  [sched_name] nvarchar(120) COLLATE Latin1_General_BIN  NOT NULL,
  [trigger_name] nvarchar(200) COLLATE Latin1_General_BIN  NOT NULL,
  [trigger_group] nvarchar(200) COLLATE Latin1_General_BIN  NOT NULL,
  [cron_expression] nvarchar(200) COLLATE Latin1_General_BIN  NOT NULL,
  [time_zone_id] nvarchar(80) COLLATE Latin1_General_BIN DEFAULT NULL NULL
)
GO

ALTER TABLE [dbo].[qrtz_cron_triggers] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of qrtz_cron_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_fired_triggers
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_fired_triggers]') AND type IN ('U'))
	DROP TABLE [dbo].[qrtz_fired_triggers]
GO

CREATE TABLE [dbo].[qrtz_fired_triggers] (
  [sched_name] nvarchar(120) COLLATE Latin1_General_BIN  NOT NULL,
  [entry_id] nvarchar(95) COLLATE Latin1_General_BIN  NOT NULL,
  [trigger_name] nvarchar(200) COLLATE Latin1_General_BIN  NOT NULL,
  [trigger_group] nvarchar(200) COLLATE Latin1_General_BIN  NOT NULL,
  [instance_name] nvarchar(200) COLLATE Latin1_General_BIN  NOT NULL,
  [fired_time] bigint  NOT NULL,
  [sched_time] bigint  NOT NULL,
  [priority] int  NOT NULL,
  [state] nvarchar(16) COLLATE Latin1_General_BIN  NOT NULL,
  [job_name] nvarchar(200) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [job_group] nvarchar(200) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [is_nonconcurrent] nvarchar(1) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [requests_recovery] nvarchar(1) COLLATE Latin1_General_BIN DEFAULT NULL NULL
)
GO

ALTER TABLE [dbo].[qrtz_fired_triggers] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of qrtz_fired_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_job_details
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_job_details]') AND type IN ('U'))
	DROP TABLE [dbo].[qrtz_job_details]
GO

CREATE TABLE [dbo].[qrtz_job_details] (
  [sched_name] nvarchar(120) COLLATE Latin1_General_BIN  NOT NULL,
  [job_name] nvarchar(200) COLLATE Latin1_General_BIN  NOT NULL,
  [job_group] nvarchar(200) COLLATE Latin1_General_BIN  NOT NULL,
  [description] nvarchar(250) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [job_class_name] nvarchar(250) COLLATE Latin1_General_BIN  NOT NULL,
  [is_durable] nvarchar(1) COLLATE Latin1_General_BIN  NOT NULL,
  [is_nonconcurrent] nvarchar(1) COLLATE Latin1_General_BIN  NOT NULL,
  [is_update_data] nvarchar(1) COLLATE Latin1_General_BIN  NOT NULL,
  [requests_recovery] nvarchar(1) COLLATE Latin1_General_BIN  NOT NULL,
  [job_data] varbinary(max)  NULL
)
GO

ALTER TABLE [dbo].[qrtz_job_details] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of qrtz_job_details
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_locks
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_locks]') AND type IN ('U'))
	DROP TABLE [dbo].[qrtz_locks]
GO

CREATE TABLE [dbo].[qrtz_locks] (
  [sched_name] nvarchar(120) COLLATE Latin1_General_BIN  NOT NULL,
  [lock_name] nvarchar(40) COLLATE Latin1_General_BIN  NOT NULL
)
GO

ALTER TABLE [dbo].[qrtz_locks] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of qrtz_locks
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_paused_trigger_grps
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_paused_trigger_grps]') AND type IN ('U'))
	DROP TABLE [dbo].[qrtz_paused_trigger_grps]
GO

CREATE TABLE [dbo].[qrtz_paused_trigger_grps] (
  [sched_name] nvarchar(120) COLLATE Latin1_General_BIN  NOT NULL,
  [trigger_group] nvarchar(200) COLLATE Latin1_General_BIN  NOT NULL
)
GO

ALTER TABLE [dbo].[qrtz_paused_trigger_grps] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of qrtz_paused_trigger_grps
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_scheduler_state
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_scheduler_state]') AND type IN ('U'))
	DROP TABLE [dbo].[qrtz_scheduler_state]
GO

CREATE TABLE [dbo].[qrtz_scheduler_state] (
  [sched_name] nvarchar(120) COLLATE Latin1_General_BIN  NOT NULL,
  [instance_name] nvarchar(200) COLLATE Latin1_General_BIN  NOT NULL,
  [last_checkin_time] bigint  NOT NULL,
  [checkin_interval] bigint  NOT NULL
)
GO

ALTER TABLE [dbo].[qrtz_scheduler_state] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of qrtz_scheduler_state
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_simple_triggers
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_simple_triggers]') AND type IN ('U'))
	DROP TABLE [dbo].[qrtz_simple_triggers]
GO

CREATE TABLE [dbo].[qrtz_simple_triggers] (
  [sched_name] nvarchar(120) COLLATE Latin1_General_BIN  NOT NULL,
  [trigger_name] nvarchar(200) COLLATE Latin1_General_BIN  NOT NULL,
  [trigger_group] nvarchar(200) COLLATE Latin1_General_BIN  NOT NULL,
  [repeat_count] bigint  NOT NULL,
  [repeat_interval] bigint  NOT NULL,
  [times_triggered] bigint  NOT NULL
)
GO

ALTER TABLE [dbo].[qrtz_simple_triggers] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of qrtz_simple_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_simprop_triggers
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_simprop_triggers]') AND type IN ('U'))
	DROP TABLE [dbo].[qrtz_simprop_triggers]
GO

CREATE TABLE [dbo].[qrtz_simprop_triggers] (
  [sched_name] nvarchar(120) COLLATE Latin1_General_BIN  NOT NULL,
  [trigger_name] nvarchar(200) COLLATE Latin1_General_BIN  NOT NULL,
  [trigger_group] nvarchar(200) COLLATE Latin1_General_BIN  NOT NULL,
  [str_prop_1] nvarchar(512) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [str_prop_2] nvarchar(512) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [str_prop_3] nvarchar(512) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [int_prop_1] int DEFAULT NULL NULL,
  [int_prop_2] int DEFAULT NULL NULL,
  [long_prop_1] bigint DEFAULT NULL NULL,
  [long_prop_2] bigint DEFAULT NULL NULL,
  [dec_prop_1] decimal(13,4) DEFAULT NULL NULL,
  [dec_prop_2] decimal(13,4) DEFAULT NULL NULL,
  [bool_prop_1] nvarchar(1) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [bool_prop_2] nvarchar(1) COLLATE Latin1_General_BIN DEFAULT NULL NULL
)
GO

ALTER TABLE [dbo].[qrtz_simprop_triggers] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of qrtz_simprop_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for qrtz_triggers
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[qrtz_triggers]') AND type IN ('U'))
	DROP TABLE [dbo].[qrtz_triggers]
GO

CREATE TABLE [dbo].[qrtz_triggers] (
  [sched_name] nvarchar(120) COLLATE Latin1_General_BIN  NOT NULL,
  [trigger_name] nvarchar(200) COLLATE Latin1_General_BIN  NOT NULL,
  [trigger_group] nvarchar(200) COLLATE Latin1_General_BIN  NOT NULL,
  [job_name] nvarchar(200) COLLATE Latin1_General_BIN  NOT NULL,
  [job_group] nvarchar(200) COLLATE Latin1_General_BIN  NOT NULL,
  [description] nvarchar(250) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [next_fire_time] bigint DEFAULT NULL NULL,
  [prev_fire_time] bigint DEFAULT NULL NULL,
  [priority] int DEFAULT NULL NULL,
  [trigger_state] nvarchar(16) COLLATE Latin1_General_BIN  NOT NULL,
  [trigger_type] nvarchar(8) COLLATE Latin1_General_BIN  NOT NULL,
  [start_time] bigint  NOT NULL,
  [end_time] bigint DEFAULT NULL NULL,
  [calendar_name] nvarchar(200) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [misfire_instr] smallint DEFAULT NULL NULL,
  [job_data] varbinary(max)  NULL
)
GO

ALTER TABLE [dbo].[qrtz_triggers] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of qrtz_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_config]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_config]
GO

CREATE TABLE [dbo].[sys_config] (
  [config_id] int  IDENTITY(7,1) NOT NULL,
  [config_name] nvarchar(100) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [config_key] nvarchar(100) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [config_value] nvarchar(500) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [config_type] nchar(1) COLLATE Latin1_General_BIN DEFAULT (N'N') NULL,
  [create_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [create_time] datetime2(0) DEFAULT NULL NULL,
  [update_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [update_time] datetime2(0) DEFAULT NULL NULL,
  [remark] nvarchar(500) COLLATE Latin1_General_BIN DEFAULT NULL NULL
)
GO

ALTER TABLE [dbo].[sys_config] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_config
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_config] ON
GO

INSERT INTO [dbo].[sys_config] ([config_id], [config_name], [config_key], [config_value], [config_type], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1', N'主框架页-默认皮肤样式名称', N'sys.index.skinName', N'skin-blue', N'Y', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow')
GO

INSERT INTO [dbo].[sys_config] ([config_id], [config_name], [config_key], [config_value], [config_type], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'2', N'用户管理-账号初始密码', N'sys.user.initPassword', N'123456', N'Y', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'初始化密码 123456')
GO

INSERT INTO [dbo].[sys_config] ([config_id], [config_name], [config_key], [config_value], [config_type], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'3', N'主框架页-侧边栏主题', N'sys.index.sideTheme', N'theme-dark', N'Y', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'深色主题theme-dark，浅色主题theme-light')
GO

INSERT INTO [dbo].[sys_config] ([config_id], [config_name], [config_key], [config_value], [config_type], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'4', N'账号自助-验证码开关', N'sys.account.captchaEnabled', N'true', N'Y', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'是否开启验证码功能（true开启，false关闭）')
GO

INSERT INTO [dbo].[sys_config] ([config_id], [config_name], [config_key], [config_value], [config_type], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'5', N'账号自助-是否开启用户注册功能', N'sys.account.registerUser', N'false', N'Y', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'是否开启注册用户功能（true开启，false关闭）')
GO

INSERT INTO [dbo].[sys_config] ([config_id], [config_name], [config_key], [config_value], [config_type], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'6', N'用户登录-黑名单列表', N'sys.login.blackIPList', N'', N'Y', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'设置登录IP黑名单限制，多个匹配项以;分隔，支持匹配（*通配、网段）')
GO

SET IDENTITY_INSERT [dbo].[sys_config] OFF
GO


-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_dept]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_dept]
GO

CREATE TABLE [dbo].[sys_dept] (
  [dept_id] bigint  IDENTITY(110,1) NOT NULL,
  [parent_id] bigint DEFAULT ((0)) NULL,
  [ancestors] nvarchar(50) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [dept_name] nvarchar(30) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [order_num] int DEFAULT ((0)) NULL,
  [leader] nvarchar(20) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [phone] nvarchar(11) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [email] nvarchar(50) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [status] nchar(1) COLLATE Latin1_General_BIN DEFAULT (N'0') NULL,
  [del_flag] nchar(1) COLLATE Latin1_General_BIN DEFAULT (N'0') NULL,
  [create_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [create_time] datetime2(0) DEFAULT NULL NULL,
  [update_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [update_time] datetime2(0) DEFAULT NULL NULL
)
GO

ALTER TABLE [dbo].[sys_dept] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_dept
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_dept] ON
GO

INSERT INTO [dbo].[sys_dept] ([dept_id], [parent_id], [ancestors], [dept_name], [order_num], [leader], [phone], [email], [status], [del_flag], [create_by], [create_time], [update_by], [update_time]) VALUES (N'100', N'0', N'0', N'若依科技', N'0', N'若依', N'15888888888', N'ry@qq.com', N'0', N'0', N'admin', N'2024-06-29 20:09:43', N'', NULL)
GO

INSERT INTO [dbo].[sys_dept] ([dept_id], [parent_id], [ancestors], [dept_name], [order_num], [leader], [phone], [email], [status], [del_flag], [create_by], [create_time], [update_by], [update_time]) VALUES (N'101', N'100', N'0,100', N'深圳总公司', N'1', N'若依', N'15888888888', N'ry@qq.com', N'0', N'0', N'admin', N'2024-06-29 20:09:43', N'', NULL)
GO

INSERT INTO [dbo].[sys_dept] ([dept_id], [parent_id], [ancestors], [dept_name], [order_num], [leader], [phone], [email], [status], [del_flag], [create_by], [create_time], [update_by], [update_time]) VALUES (N'102', N'100', N'0,100', N'长沙分公司', N'2', N'若依', N'15888888888', N'ry@qq.com', N'0', N'0', N'admin', N'2024-06-29 20:09:43', N'', NULL)
GO

INSERT INTO [dbo].[sys_dept] ([dept_id], [parent_id], [ancestors], [dept_name], [order_num], [leader], [phone], [email], [status], [del_flag], [create_by], [create_time], [update_by], [update_time]) VALUES (N'103', N'101', N'0,100,101', N'研发部门', N'1', N'若依', N'15888888888', N'ry@qq.com', N'0', N'0', N'admin', N'2024-06-29 20:09:43', N'', NULL)
GO

INSERT INTO [dbo].[sys_dept] ([dept_id], [parent_id], [ancestors], [dept_name], [order_num], [leader], [phone], [email], [status], [del_flag], [create_by], [create_time], [update_by], [update_time]) VALUES (N'104', N'101', N'0,100,101', N'市场部门', N'2', N'若依', N'15888888888', N'ry@qq.com', N'0', N'0', N'admin', N'2024-06-29 20:09:43', N'', NULL)
GO

INSERT INTO [dbo].[sys_dept] ([dept_id], [parent_id], [ancestors], [dept_name], [order_num], [leader], [phone], [email], [status], [del_flag], [create_by], [create_time], [update_by], [update_time]) VALUES (N'105', N'101', N'0,100,101', N'测试部门', N'3', N'若依', N'15888888888', N'ry@qq.com', N'0', N'0', N'admin', N'2024-06-29 20:09:43', N'', NULL)
GO

INSERT INTO [dbo].[sys_dept] ([dept_id], [parent_id], [ancestors], [dept_name], [order_num], [leader], [phone], [email], [status], [del_flag], [create_by], [create_time], [update_by], [update_time]) VALUES (N'106', N'101', N'0,100,101', N'财务部门', N'4', N'若依', N'15888888888', N'ry@qq.com', N'0', N'0', N'admin', N'2024-06-29 20:09:43', N'', NULL)
GO

INSERT INTO [dbo].[sys_dept] ([dept_id], [parent_id], [ancestors], [dept_name], [order_num], [leader], [phone], [email], [status], [del_flag], [create_by], [create_time], [update_by], [update_time]) VALUES (N'107', N'101', N'0,100,101', N'运维部门', N'5', N'若依', N'15888888888', N'ry@qq.com', N'0', N'0', N'admin', N'2024-06-29 20:09:43', N'', NULL)
GO

INSERT INTO [dbo].[sys_dept] ([dept_id], [parent_id], [ancestors], [dept_name], [order_num], [leader], [phone], [email], [status], [del_flag], [create_by], [create_time], [update_by], [update_time]) VALUES (N'108', N'102', N'0,100,102', N'市场部门', N'1', N'若依', N'15888888888', N'ry@qq.com', N'0', N'0', N'admin', N'2024-06-29 20:09:43', N'', NULL)
GO

INSERT INTO [dbo].[sys_dept] ([dept_id], [parent_id], [ancestors], [dept_name], [order_num], [leader], [phone], [email], [status], [del_flag], [create_by], [create_time], [update_by], [update_time]) VALUES (N'109', N'102', N'0,100,102', N'财务部门', N'2', N'若依', N'15888888888', N'ry@qq.com', N'0', N'0', N'admin', N'2024-06-29 20:09:43', N'', NULL)
GO

SET IDENTITY_INSERT [dbo].[sys_dept] OFF
GO


-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_dict_data]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_dict_data]
GO

CREATE TABLE [dbo].[sys_dict_data] (
  [dict_code] bigint  IDENTITY(30,1) NOT NULL,
  [dict_sort] int DEFAULT ((0)) NULL,
  [dict_label] nvarchar(100) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [dict_value] nvarchar(100) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [dict_type] nvarchar(100) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [css_class] nvarchar(100) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [list_class] nvarchar(100) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [is_default] nchar(1) COLLATE Latin1_General_BIN DEFAULT (N'N') NULL,
  [status] nchar(1) COLLATE Latin1_General_BIN DEFAULT (N'0') NULL,
  [create_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [create_time] datetime2(0) DEFAULT NULL NULL,
  [update_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [update_time] datetime2(0) DEFAULT NULL NULL,
  [remark] nvarchar(500) COLLATE Latin1_General_BIN DEFAULT NULL NULL
)
GO

ALTER TABLE [dbo].[sys_dict_data] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_dict_data] ON
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1', N'1', N'男', N'0', N'sys_user_sex', N'', N'', N'Y', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'性别男')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'2', N'2', N'女', N'1', N'sys_user_sex', N'', N'', N'N', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'性别女')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'3', N'3', N'未知', N'2', N'sys_user_sex', N'', N'', N'N', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'性别未知')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'4', N'1', N'显示', N'0', N'sys_show_hide', N'', N'primary', N'Y', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'显示菜单')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'5', N'2', N'隐藏', N'1', N'sys_show_hide', N'', N'danger', N'N', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'隐藏菜单')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'6', N'1', N'正常', N'0', N'sys_normal_disable', N'', N'primary', N'Y', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'正常状态')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'7', N'2', N'停用', N'1', N'sys_normal_disable', N'', N'danger', N'N', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'停用状态')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'8', N'1', N'正常', N'0', N'sys_job_status', N'', N'primary', N'Y', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'正常状态')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'9', N'2', N'暂停', N'1', N'sys_job_status', N'', N'danger', N'N', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'停用状态')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'10', N'1', N'默认', N'DEFAULT', N'sys_job_group', N'', N'', N'Y', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'默认分组')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'11', N'2', N'系统', N'SYSTEM', N'sys_job_group', N'', N'', N'N', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'系统分组')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'12', N'1', N'是', N'Y', N'sys_yes_no', N'', N'primary', N'Y', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'系统默认是')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'13', N'2', N'否', N'N', N'sys_yes_no', N'', N'danger', N'N', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'系统默认否')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'14', N'1', N'通知', N'1', N'sys_notice_type', N'', N'warning', N'Y', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'通知')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'15', N'2', N'公告', N'2', N'sys_notice_type', N'', N'success', N'N', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'公告')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'16', N'1', N'正常', N'0', N'sys_notice_status', N'', N'primary', N'Y', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'正常状态')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'17', N'2', N'关闭', N'1', N'sys_notice_status', N'', N'danger', N'N', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'关闭状态')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'18', N'99', N'其他', N'0', N'sys_oper_type', N'', N'info', N'N', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'其他操作')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'19', N'1', N'新增', N'1', N'sys_oper_type', N'', N'info', N'N', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'新增操作')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'20', N'2', N'修改', N'2', N'sys_oper_type', N'', N'info', N'N', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'修改操作')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'21', N'3', N'删除', N'3', N'sys_oper_type', N'', N'danger', N'N', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'删除操作')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'22', N'4', N'授权', N'4', N'sys_oper_type', N'', N'primary', N'N', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'授权操作')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'23', N'5', N'导出', N'5', N'sys_oper_type', N'', N'warning', N'N', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'导出操作')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'24', N'6', N'导入', N'6', N'sys_oper_type', N'', N'warning', N'N', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'导入操作')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'25', N'7', N'强退', N'7', N'sys_oper_type', N'', N'danger', N'N', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'强退操作')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'26', N'8', N'生成代码', N'8', N'sys_oper_type', N'', N'warning', N'N', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'生成操作')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'27', N'9', N'清空数据', N'9', N'sys_oper_type', N'', N'danger', N'N', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'清空操作')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'28', N'1', N'成功', N'0', N'sys_common_status', N'', N'primary', N'N', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'正常状态')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'29', N'2', N'失败', N'1', N'sys_common_status', N'', N'danger', N'N', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'停用状态')
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'30', N'1', N'Section', N'0', N'fe_menu_type', NULL, N'default', N'N', N'0', N'admin', N'2024-08-28 11:35:25', N'', NULL, NULL)
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'31', N'2', N'Question', N'1', N'fe_menu_type', NULL, N'default', N'N', N'0', N'admin', N'2024-08-28 11:35:41', N'', NULL, NULL)
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'32', N'3', N'Rate', N'2', N'fe_menu_type', NULL, N'default', N'N', N'0', N'admin', N'2024-08-28 11:35:57', N'', NULL, NULL)
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'33', N'1', N'inactive', N'0', N'fe_status', NULL, N'default', N'N', N'0', N'admin', N'2024-08-28 11:42:42', N'', NULL, NULL)
GO

INSERT INTO [dbo].[sys_dict_data] ([dict_code], [dict_sort], [dict_label], [dict_value], [dict_type], [css_class], [list_class], [is_default], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'34', N'2', N'active', N'1', N'fe_status', NULL, N'default', N'N', N'0', N'admin', N'2024-08-28 11:42:55', N'', NULL, NULL)
GO

SET IDENTITY_INSERT [dbo].[sys_dict_data] OFF
GO


-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_dict_type]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_dict_type]
GO

CREATE TABLE [dbo].[sys_dict_type] (
  [dict_id] bigint  IDENTITY(11,1) NOT NULL,
  [dict_name] nvarchar(100) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [dict_type] nvarchar(100) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [status] nchar(1) COLLATE Latin1_General_BIN DEFAULT (N'0') NULL,
  [create_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [create_time] datetime2(0) DEFAULT NULL NULL,
  [update_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [update_time] datetime2(0) DEFAULT NULL NULL,
  [remark] nvarchar(500) COLLATE Latin1_General_BIN DEFAULT NULL NULL
)
GO

ALTER TABLE [dbo].[sys_dict_type] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_dict_type] ON
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1', N'用户性别', N'sys_user_sex', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'用户性别列表')
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'2', N'菜单状态', N'sys_show_hide', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'菜单状态列表')
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'3', N'系统开关', N'sys_normal_disable', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'系统开关列表')
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'4', N'任务状态', N'sys_job_status', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'任务状态列表')
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'5', N'任务分组', N'sys_job_group', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'任务分组列表')
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'6', N'系统是否', N'sys_yes_no', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'系统是否列表')
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'7', N'通知类型', N'sys_notice_type', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'通知类型列表')
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'8', N'通知状态', N'sys_notice_status', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'通知状态列表')
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'9', N'操作类型', N'sys_oper_type', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'操作类型列表')
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'10', N'系统状态', N'sys_common_status', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'登录状态列表')
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'11', N'FeMenuType', N'fe_menu_type', N'0', N'admin', N'2024-08-28 10:50:15', N'', NULL, N'Factory Evaluation Menu Type')
GO

INSERT INTO [dbo].[sys_dict_type] ([dict_id], [dict_name], [dict_type], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'12', N'FeStatus', N'fe_status', N'0', N'admin', N'2024-08-28 11:42:04', N'', NULL, NULL)
GO

SET IDENTITY_INSERT [dbo].[sys_dict_type] OFF
GO


-- ----------------------------
-- Table structure for sys_job
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_job]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_job]
GO

CREATE TABLE [dbo].[sys_job] (
  [job_id] bigint  IDENTITY(4,1) NOT NULL,
  [job_name] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NOT NULL,
  [job_group] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'DEFAULT') NOT NULL,
  [invoke_target] nvarchar(500) COLLATE Latin1_General_BIN  NOT NULL,
  [cron_expression] nvarchar(255) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [misfire_policy] nvarchar(20) COLLATE Latin1_General_BIN DEFAULT (N'3') NULL,
  [concurrent] nchar(1) COLLATE Latin1_General_BIN DEFAULT (N'1') NULL,
  [status] nchar(1) COLLATE Latin1_General_BIN DEFAULT (N'0') NULL,
  [create_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [create_time] datetime2(0) DEFAULT NULL NULL,
  [update_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [update_time] datetime2(0) DEFAULT NULL NULL,
  [remark] nvarchar(500) COLLATE Latin1_General_BIN DEFAULT (N'') NULL
)
GO

ALTER TABLE [dbo].[sys_job] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_job
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_job] ON
GO

INSERT INTO [dbo].[sys_job] ([job_id], [job_name], [job_group], [invoke_target], [cron_expression], [misfire_policy], [concurrent], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1', N'系统默认（无参）', N'DEFAULT', N'ryTask.ryNoParams', N'0/10 * * * * ?', N'3', N'1', N'1', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_job] ([job_id], [job_name], [job_group], [invoke_target], [cron_expression], [misfire_policy], [concurrent], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'2', N'系统默认（有参）', N'DEFAULT', N'ryTask.ryParams(''ry'')', N'0/15 * * * * ?', N'3', N'1', N'1', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_job] ([job_id], [job_name], [job_group], [invoke_target], [cron_expression], [misfire_policy], [concurrent], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'3', N'系统默认（多参）', N'DEFAULT', N'ryTask.ryMultipleParams(''ry'', true, 2000L, 316.50D, 100)', N'0/20 * * * * ?', N'3', N'1', N'1', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

SET IDENTITY_INSERT [dbo].[sys_job] OFF
GO


-- ----------------------------
-- Table structure for sys_job_log
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_job_log]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_job_log]
GO

CREATE TABLE [dbo].[sys_job_log] (
  [job_log_id] bigint  IDENTITY(1,1) NOT NULL,
  [job_name] nvarchar(64) COLLATE Latin1_General_BIN  NOT NULL,
  [job_group] nvarchar(64) COLLATE Latin1_General_BIN  NOT NULL,
  [invoke_target] nvarchar(500) COLLATE Latin1_General_BIN  NOT NULL,
  [job_message] nvarchar(500) COLLATE Latin1_General_BIN DEFAULT NULL NULL,
  [status] nchar(1) COLLATE Latin1_General_BIN DEFAULT (N'0') NULL,
  [exception_info] nvarchar(2000) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [create_time] datetime2(0) DEFAULT NULL NULL
)
GO

ALTER TABLE [dbo].[sys_job_log] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_job_log
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_job_log] ON
GO

SET IDENTITY_INSERT [dbo].[sys_job_log] OFF
GO


-- ----------------------------
-- Table structure for sys_logininfor
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_logininfor]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_logininfor]
GO

CREATE TABLE [dbo].[sys_logininfor] (
  [info_id] bigint  IDENTITY(101,1) NOT NULL,
  [user_name] nvarchar(50) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [ipaddr] nvarchar(128) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [login_location] nvarchar(255) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [browser] nvarchar(50) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [os] nvarchar(50) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [status] nchar(1) COLLATE Latin1_General_BIN DEFAULT (N'0') NULL,
  [msg] nvarchar(255) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [login_time] datetime2(0) DEFAULT NULL NULL
)
GO

ALTER TABLE [dbo].[sys_logininfor] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_logininfor
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_logininfor] ON
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'100', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'0', N'登录成功', N'2024-07-04 11:15:40')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'101', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'0', N'登录成功', N'2024-07-05 15:04:04')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'102', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'0', N'登录成功', N'2024-07-06 10:35:22')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'103', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'0', N'登录成功', N'2024-07-31 16:55:01')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'104', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'0', N'登录成功', N'2024-08-09 15:47:15')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'105', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'0', N'登录成功', N'2024-08-09 16:38:54')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'106', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'0', N'登录成功', N'2024-08-13 11:11:36')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'107', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'0', N'登录成功', N'2024-08-13 12:08:15')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'108', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'0', N'登录成功', N'2024-08-13 14:09:25')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'109', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'0', N'登录成功', N'2024-08-13 16:15:59')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'110', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'0', N'登录成功', N'2024-08-14 11:03:12')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'111', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'1', N'验证码错误', N'2024-08-14 14:11:37')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'112', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'0', N'登录成功', N'2024-08-14 14:11:43')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'113', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'0', N'登录成功', N'2024-08-28 09:41:44')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'114', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'0', N'登录成功', N'2024-08-28 10:16:34')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'115', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'0', N'登录成功', N'2024-08-28 11:35:01')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'116', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'0', N'登录成功', N'2024-08-28 14:17:51')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'117', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'1', N'验证码已失效', N'2024-08-28 15:10:07')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'118', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'0', N'登录成功', N'2024-08-28 15:10:12')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'119', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'1', N'验证码已失效', N'2024-09-20 12:17:08')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'120', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'0', N'登录成功', N'2024-09-20 12:17:25')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'121', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'1', N'验证码错误', N'2024-09-24 22:24:38')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'122', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'0', N'登录成功', N'2024-09-24 22:24:47')
GO

INSERT INTO [dbo].[sys_logininfor] ([info_id], [user_name], [ipaddr], [login_location], [browser], [os], [status], [msg], [login_time]) VALUES (N'123', N'admin', N'127.0.0.1', N'内网IP', N'Chrome 12', N'Windows 10', N'0', N'登录成功', N'2024-10-11 17:27:40')
GO

SET IDENTITY_INSERT [dbo].[sys_logininfor] OFF
GO


-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_menu]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_menu]
GO

CREATE TABLE [dbo].[sys_menu] (
  [menu_id] bigint  IDENTITY(1,1) NOT NULL,
  [menu_name] nvarchar(50) COLLATE Latin1_General_BIN  NOT NULL,
  [parent_id] bigint  NULL,
  [order_num] int  NULL,
  [path] nvarchar(200) COLLATE Latin1_General_BIN  NULL,
  [component] nvarchar(255) COLLATE Latin1_General_BIN  NULL,
  [query] nvarchar(255) COLLATE Latin1_General_BIN  NULL,
  [route_name] nvarchar(50) COLLATE Latin1_General_BIN  NULL,
  [is_frame] int  NULL,
  [is_cache] int  NULL,
  [menu_type] nchar(1) COLLATE Latin1_General_BIN  NULL,
  [visible] nchar(1) COLLATE Latin1_General_BIN  NULL,
  [status] nchar(1) COLLATE Latin1_General_BIN  NULL,
  [perms] nvarchar(100) COLLATE Latin1_General_BIN  NULL,
  [icon] nvarchar(100) COLLATE Latin1_General_BIN  NULL,
  [create_by] nvarchar(64) COLLATE Latin1_General_BIN  NULL,
  [create_time] datetime2(0)  NULL,
  [update_by] nvarchar(64) COLLATE Latin1_General_BIN  NULL,
  [update_time] datetime2(0)  NULL,
  [remark] nvarchar(500) COLLATE Latin1_General_BIN  NULL
)
GO

ALTER TABLE [dbo].[sys_menu] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单ID',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'menu_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'menu_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'父菜单ID',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'parent_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'显示顺序',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'order_num'
GO

EXEC sp_addextendedproperty
'MS_Description', N'路由地址',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'path'
GO

EXEC sp_addextendedproperty
'MS_Description', N'组件路径',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'component'
GO

EXEC sp_addextendedproperty
'MS_Description', N'路由参数',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'query'
GO

EXEC sp_addextendedproperty
'MS_Description', N'路由名称',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'route_name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否为外链（0是 1否）',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'is_frame'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否缓存（0缓存 1不缓存）',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'is_cache'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单类型（M目录 C菜单 F按钮）',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'menu_type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单状态（0显示 1隐藏）',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'visible'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单状态（0正常 1停用）',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'权限标识',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'perms'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单图标',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'icon'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建者',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'create_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新者',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'update_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'更新时间',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu',
'COLUMN', N'remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单权限表',
'SCHEMA', N'dbo',
'TABLE', N'sys_menu'
GO


-- ----------------------------
-- Records of sys_menu
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_menu] ON
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1', N'系统管理', N'0', N'1', N'system', NULL, N'', N'', N'1', N'0', N'M', N'0', N'0', N'', N'system', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'系统管理目录')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'2', N'系统监控', N'0', N'2', N'monitor', NULL, N'', N'', N'1', N'0', N'M', N'0', N'0', N'', N'monitor', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'系统监控目录')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'3', N'系统工具', N'0', N'3', N'tool', NULL, N'', N'', N'1', N'0', N'M', N'0', N'0', N'', N'tool', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'系统工具目录')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'4', N'若依官网', N'0', N'4', N'http://ruoyi.vip', NULL, N'', N'', N'0', N'0', N'M', N'0', N'0', N'', N'guide', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'若依官网地址')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'100', N'用户管理', N'1', N'1', N'user', N'system/user/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'system:user:list', N'user', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'用户管理菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'101', N'角色管理', N'1', N'2', N'role', N'system/role/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'system:role:list', N'peoples', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'角色管理菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'102', N'菜单管理', N'1', N'3', N'menu', N'system/menu/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'system:menu:list', N'tree-table', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'菜单管理菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'103', N'部门管理', N'1', N'4', N'dept', N'system/dept/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'system:dept:list', N'tree', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'部门管理菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'104', N'岗位管理', N'1', N'5', N'post', N'system/post/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'system:post:list', N'post', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'岗位管理菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'105', N'字典管理', N'1', N'6', N'dict', N'system/dict/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'system:dict:list', N'dict', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'字典管理菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'106', N'参数设置', N'1', N'7', N'config', N'system/config/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'system:config:list', N'edit', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'参数设置菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'107', N'通知公告', N'1', N'8', N'notice', N'system/notice/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'system:notice:list', N'message', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'通知公告菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'108', N'日志管理', N'1', N'9', N'log', N'', N'', N'', N'1', N'0', N'M', N'0', N'0', N'', N'log', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'日志管理菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'109', N'在线用户', N'2', N'1', N'online', N'monitor/online/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'monitor:online:list', N'online', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'在线用户菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'110', N'定时任务', N'2', N'2', N'job', N'monitor/job/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'monitor:job:list', N'job', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'定时任务菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'111', N'数据监控', N'2', N'3', N'druid', N'monitor/druid/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'monitor:druid:list', N'druid', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'数据监控菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'112', N'服务监控', N'2', N'4', N'server', N'monitor/server/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'monitor:server:list', N'server', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'服务监控菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'113', N'缓存监控', N'2', N'5', N'cache', N'monitor/cache/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'monitor:cache:list', N'redis', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'缓存监控菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'114', N'缓存列表', N'2', N'6', N'cacheList', N'monitor/cache/list', N'', N'', N'1', N'0', N'C', N'0', N'0', N'monitor:cache:list', N'redis-list', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'缓存列表菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'115', N'表单构建', N'3', N'1', N'build', N'tool/build/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'tool:build:list', N'build', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'表单构建菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'116', N'代码生成', N'3', N'2', N'gen', N'tool/gen/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'tool:gen:list', N'code', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'代码生成菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'117', N'系统接口', N'3', N'3', N'swagger', N'tool/swagger/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'tool:swagger:list', N'swagger', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'系统接口菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'500', N'操作日志', N'108', N'1', N'operlog', N'monitor/operlog/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'monitor:operlog:list', N'form', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'操作日志菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'501', N'登录日志', N'108', N'2', N'logininfor', N'monitor/logininfor/index', N'', N'', N'1', N'0', N'C', N'0', N'0', N'monitor:logininfor:list', N'logininfor', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'登录日志菜单')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1000', N'用户查询', N'100', N'1', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:user:query', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1001', N'用户新增', N'100', N'2', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:user:add', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1002', N'用户修改', N'100', N'3', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:user:edit', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1003', N'用户删除', N'100', N'4', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:user:remove', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1004', N'用户导出', N'100', N'5', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:user:export', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1005', N'用户导入', N'100', N'6', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:user:import', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1006', N'重置密码', N'100', N'7', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:user:resetPwd', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1007', N'角色查询', N'101', N'1', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:role:query', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1008', N'角色新增', N'101', N'2', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:role:add', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1009', N'角色修改', N'101', N'3', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:role:edit', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1010', N'角色删除', N'101', N'4', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:role:remove', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1011', N'角色导出', N'101', N'5', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:role:export', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1012', N'菜单查询', N'102', N'1', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:menu:query', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1013', N'菜单新增', N'102', N'2', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:menu:add', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1014', N'菜单修改', N'102', N'3', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:menu:edit', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1015', N'菜单删除', N'102', N'4', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:menu:remove', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1016', N'部门查询', N'103', N'1', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:dept:query', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1017', N'部门新增', N'103', N'2', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:dept:add', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1018', N'部门修改', N'103', N'3', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:dept:edit', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1019', N'部门删除', N'103', N'4', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:dept:remove', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1020', N'岗位查询', N'104', N'1', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:post:query', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1021', N'岗位新增', N'104', N'2', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:post:add', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1022', N'岗位修改', N'104', N'3', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:post:edit', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1023', N'岗位删除', N'104', N'4', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:post:remove', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1024', N'岗位导出', N'104', N'5', N'', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:post:export', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1025', N'字典查询', N'105', N'1', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:dict:query', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1026', N'字典新增', N'105', N'2', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:dict:add', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1027', N'字典修改', N'105', N'3', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:dict:edit', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1028', N'字典删除', N'105', N'4', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:dict:remove', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1029', N'字典导出', N'105', N'5', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:dict:export', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1030', N'参数查询', N'106', N'1', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:config:query', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1031', N'参数新增', N'106', N'2', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:config:add', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1032', N'参数修改', N'106', N'3', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:config:edit', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1033', N'参数删除', N'106', N'4', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:config:remove', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1034', N'参数导出', N'106', N'5', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:config:export', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1035', N'公告查询', N'107', N'1', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:notice:query', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1036', N'公告新增', N'107', N'2', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:notice:add', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1037', N'公告修改', N'107', N'3', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:notice:edit', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1038', N'公告删除', N'107', N'4', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'system:notice:remove', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1039', N'操作查询', N'500', N'1', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'monitor:operlog:query', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1040', N'操作删除', N'500', N'2', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'monitor:operlog:remove', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1041', N'日志导出', N'500', N'3', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'monitor:operlog:export', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1042', N'登录查询', N'501', N'1', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'monitor:logininfor:query', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1043', N'登录删除', N'501', N'2', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'monitor:logininfor:remove', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1044', N'日志导出', N'501', N'3', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'monitor:logininfor:export', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1045', N'账户解锁', N'501', N'4', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'monitor:logininfor:unlock', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1046', N'在线查询', N'109', N'1', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'monitor:online:query', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1047', N'批量强退', N'109', N'2', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'monitor:online:batchLogout', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1048', N'单条强退', N'109', N'3', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'monitor:online:forceLogout', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1049', N'任务查询', N'110', N'1', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'monitor:job:query', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1050', N'任务新增', N'110', N'2', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'monitor:job:add', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1051', N'任务修改', N'110', N'3', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'monitor:job:edit', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1052', N'任务删除', N'110', N'4', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'monitor:job:remove', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1053', N'状态修改', N'110', N'5', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'monitor:job:changeStatus', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1054', N'任务导出', N'110', N'6', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'monitor:job:export', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1055', N'生成查询', N'116', N'1', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'tool:gen:query', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1056', N'生成修改', N'116', N'2', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'tool:gen:edit', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1057', N'生成删除', N'116', N'3', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'tool:gen:remove', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1058', N'导入代码', N'116', N'4', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'tool:gen:import', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1059', N'预览代码', N'116', N'5', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'tool:gen:preview', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1060', N'生成代码', N'116', N'6', N'#', N'', N'', N'', N'1', N'0', N'F', N'0', N'0', N'tool:gen:code', N'#', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1062', N'table test', N'3', N'1', N'user', N'system/user/index', NULL, NULL, N'1', N'0', N'C', N'0', N'0', N'system:user:list', N'#', N'admin', N'2024-08-28 16:17:41', N'', NULL, N'table test Menu')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1063', N'Menu', N'1069', N'1', N'femenu', N'fe/femenu/index', NULL, NULL, N'1', N'0', N'C', N'0', N'0', N'fe:femenu:list', N'education', N'admin', N'2024-08-28 16:52:30', N'admin', N'2024-08-28 17:36:20', N'Factory Evaluation Menu')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1064', N'Menu Query', N'1063', N'1', N'#', N'', NULL, NULL, N'1', N'0', N'F', N'0', N'0', N'fe:femenu:query', N'#', N'admin', N'2024-08-28 16:58:25', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1065', N'Menu Add', N'1063', N'2', N'#', N'', NULL, NULL, N'1', N'0', N'F', N'0', N'0', N'fe:femenu:add', N'#', N'admin', N'2024-08-28 16:58:25', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1066', N'Menu Edit', N'1063', N'3', N'#', N'', NULL, NULL, N'1', N'0', N'F', N'0', N'0', N'fe:femenu:edit', N'#', N'admin', N'2024-08-28 16:58:25', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1067', N'Menu Remove', N'1063', N'4', N'#', N'', NULL, NULL, N'1', N'0', N'F', N'0', N'0', N'fe:femenu:remove', N'#', N'admin', N'2024-08-28 16:58:25', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1068', N'Menu Export', N'1063', N'5', N'#', N'', NULL, NULL, N'1', N'0', N'F', N'0', N'0', N'fe:femenu:export', N'#', N'admin', N'2024-08-28 16:58:25', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_menu] ([menu_id], [menu_name], [parent_id], [order_num], [path], [component], [query], [route_name], [is_frame], [is_cache], [menu_type], [visible], [status], [perms], [icon], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1069', N'Factory Evaluation', N'0', N'5', N'fe', NULL, NULL, NULL, N'1', N'0', N'M', N'0', N'0', NULL, N'tab', N'admin', N'2024-08-28 17:34:34', NULL, NULL, NULL)
GO

SET IDENTITY_INSERT [dbo].[sys_menu] OFF
GO


-- ----------------------------
-- Table structure for sys_notice
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_notice]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_notice]
GO

CREATE TABLE [dbo].[sys_notice] (
  [notice_id] int  IDENTITY(3,1) NOT NULL,
  [notice_title] nvarchar(50) COLLATE Latin1_General_BIN  NOT NULL,
  [notice_type] nchar(1) COLLATE Latin1_General_BIN  NOT NULL,
  [notice_content] varbinary(max)  NULL,
  [status] nchar(1) COLLATE Latin1_General_BIN DEFAULT (N'0') NULL,
  [create_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [create_time] datetime2(0) DEFAULT NULL NULL,
  [update_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [update_time] datetime2(0) DEFAULT NULL NULL,
  [remark] nvarchar(255) COLLATE Latin1_General_BIN DEFAULT NULL NULL
)
GO

ALTER TABLE [dbo].[sys_notice] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_notice
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_notice] ON
GO

INSERT INTO [dbo].[sys_notice] ([notice_id], [notice_title], [notice_type], [notice_content], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1', N'温馨提醒：2018-07-01 若依新版本发布啦', N'2', 0xE696B0E78988E69CACE58685E5AEB9, N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'管理员')
GO

INSERT INTO [dbo].[sys_notice] ([notice_id], [notice_title], [notice_type], [notice_content], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'2', N'维护通知：2018-07-01 若依系统凌晨维护', N'1', 0xE7BBB4E68AA4E58685E5AEB9, N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'管理员')
GO

SET IDENTITY_INSERT [dbo].[sys_notice] OFF
GO


-- ----------------------------
-- Table structure for sys_oper_log
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_oper_log]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_oper_log]
GO

CREATE TABLE [dbo].[sys_oper_log] (
  [oper_id] bigint  IDENTITY(1,1) NOT NULL,
  [title] nvarchar(50) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [business_type] int DEFAULT ((0)) NULL,
  [method] nvarchar(200) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [request_method] nvarchar(10) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [operator_type] int DEFAULT ((0)) NULL,
  [oper_name] nvarchar(50) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [dept_name] nvarchar(50) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [oper_url] nvarchar(255) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [oper_ip] nvarchar(128) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [oper_location] nvarchar(255) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [oper_param] nvarchar(2000) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [json_result] nvarchar(2000) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [status] int DEFAULT ((0)) NULL,
  [error_msg] nvarchar(2000) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [oper_time] datetime2(0) DEFAULT NULL NULL,
  [cost_time] bigint DEFAULT ((0)) NULL
)
GO

ALTER TABLE [dbo].[sys_oper_log] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_oper_log
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_oper_log] ON
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'1', N'用户管理', N'1', N'com.jack.web.controller.system.SysUserController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/user', N'127.0.0.1', N'内网IP', N'{"admin":false,"createBy":"admin","nickName":"jack","params":{},"postIds":[],"roleIds":[2],"status":"0","userId":3,"userName":"jackcheng"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-07-05 15:04:36', N'193')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'2', N'用户管理', N'2', N'com.jack.web.controller.system.SysUserController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/user', N'127.0.0.1', N'内网IP', N'{"admin":false,"avatar":"","createBy":"admin","createTime":"2024-07-05 15:04:36","delFlag":"0","deptId":100,"email":"","loginIp":"","nickName":"jack","params":{},"phonenumber":"","postIds":[2],"roleIds":[2],"roles":[{"admin":false,"dataScope":"2","deptCheckStrictly":false,"flag":false,"menuCheckStrictly":false,"params":{},"roleId":2,"roleKey":"common","roleName":"普通角色","roleSort":2,"status":"0"}],"sex":"0","status":"0","updateBy":"admin","userId":3,"userName":"jackcheng"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-07-05 15:04:57', N'113')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'3', N'菜单管理', N'1', N'com.jack.web.controller.system.SysMenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"icon":"form","isCache":"0","isFrame":"1","menuName":"Factory Evaluation","menuType":"M","orderNum":5,"params":{},"parentId":0,"path":"factoryeva","status":"0","visible":"0"}', NULL, N'1', N'
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.
### The error may exist in file [D:\myIdea\contempo\qc_2024\qc_server\qc-system\target\classes\mapper\system\SysMenuMapper.xml]
### The error may involve com.jack.system.mapper.SysMenuMapper.checkMenuNameUnique-Inline
### The error occurred while setting parameters
### SQL: select menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, isnull(perms,'''') as perms, icon, create_time   from sys_menu         where menu_name=? and parent_id = ? top 1
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.
; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.', N'2024-08-13 16:44:06', N'115')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'4', N'菜单管理', N'1', N'com.jack.web.controller.system.SysMenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"icon":"form","isCache":"0","isFrame":"1","menuName":"Factory Evaluation","menuType":"M","orderNum":5,"params":{},"parentId":0,"path":"factoryeva","status":"0","visible":"0"}', NULL, N'1', N'
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.
### The error may exist in file [D:\myIdea\contempo\qc_2024\qc_server\qc-system\target\classes\mapper\system\SysMenuMapper.xml]
### The error may involve com.jack.system.mapper.SysMenuMapper.checkMenuNameUnique-Inline
### The error occurred while setting parameters
### SQL: select menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, isnull(perms,'''') as perms, icon, create_time   from sys_menu         where menu_name=? and parent_id = ? top 1
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.
; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.', N'2024-08-13 16:44:13', N'12')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'5', N'菜单管理', N'1', N'com.jack.web.controller.system.SysMenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"icon":"form","isCache":"0","isFrame":"1","menuName":"FactoryEvaluation","menuType":"M","orderNum":5,"params":{},"parentId":0,"path":"factoryeva","status":"0","visible":"0"}', NULL, N'1', N'
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.
### The error may exist in file [D:\myIdea\contempo\qc_2024\qc_server\qc-system\target\classes\mapper\system\SysMenuMapper.xml]
### The error may involve com.jack.system.mapper.SysMenuMapper.checkMenuNameUnique-Inline
### The error occurred while setting parameters
### SQL: select menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, isnull(perms,'''') as perms, icon, create_time   from sys_menu         where menu_name=? and parent_id = ? top 1
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.
; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.', N'2024-08-13 16:45:37', N'48')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'6', N'菜单管理', N'1', N'com.jack.web.controller.system.SysMenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"icon":"form","isCache":"0","isFrame":"1","menuName":"FactoryEvaluation","menuType":"M","orderNum":5,"params":{},"parentId":0,"path":"factoryeva","status":"0","visible":"0"}', NULL, N'1', N'
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.
### The error may exist in file [D:\myIdea\contempo\qc_2024\qc_server\qc-system\target\classes\mapper\system\SysMenuMapper.xml]
### The error may involve com.jack.system.mapper.SysMenuMapper.checkMenuNameUnique-Inline
### The error occurred while setting parameters
### SQL: select menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, isnull(perms,'''') as perms, icon, create_time   from sys_menu         where menu_name=? and parent_id = ? top 1
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.
; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.', N'2024-08-13 16:46:28', N'12')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'7', N'菜单管理', N'1', N'com.jack.web.controller.system.SysMenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"icon":"form","isCache":"0","isFrame":"1","menuName":"FactoryEvaluation","menuType":"M","orderNum":5,"params":{},"parentId":0,"path":"factoryeva","status":"0","visible":"0"}', NULL, N'1', N'
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.
### The error may exist in file [D:\myIdea\contempo\qc_2024\qc_server\qc-system\target\classes\mapper\system\SysMenuMapper.xml]
### The error may involve com.jack.system.mapper.SysMenuMapper.checkMenuNameUnique-Inline
### The error occurred while setting parameters
### SQL: select menu_id, menu_name, parent_id, order_num, path, component, query, route_name, is_frame, is_cache, menu_type, visible, status, isnull(perms,'''') as perms, icon, create_time   from sys_menu         where menu_name=? and parent_id = ? top 1
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.
; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.', N'2024-08-13 16:53:54', N'38')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'8', N'菜单管理', N'1', N'com.jack.web.controller.system.SysMenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"icon":"form","isCache":"0","isFrame":"1","menuName":"Factory Evaluation","menuType":"M","orderNum":5,"params":{},"parentId":0,"path":"factoryeva","status":"0","visible":"0"}', NULL, N'1', N'nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property=''menuName'', mode=IN, javaType=class java.lang.String, jdbcType=null, numericScale=null, resultMapId=''null'', jdbcTypeName=''null'', expression=''null''}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #3 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 索引 3 超出范围。', N'2024-08-13 16:55:08', N'14')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'9', N'菜单管理', N'1', N'com.jack.web.controller.system.SysMenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"icon":"form","isCache":"0","isFrame":"1","menuName":"Factory Evaluation","menuType":"M","orderNum":5,"params":{},"parentId":0,"path":"factoryeva","status":"0","visible":"0"}', NULL, N'1', N'nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property=''menuName'', mode=IN, javaType=class java.lang.String, jdbcType=null, numericScale=null, resultMapId=''null'', jdbcTypeName=''null'', expression=''null''}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #3 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 索引 3 超出范围。', N'2024-08-13 16:55:13', N'1')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'10', N'菜单管理', N'1', N'com.jack.web.controller.system.SysMenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"icon":"form","isCache":"0","isFrame":"1","menuName":"FactoryEvaluation","menuType":"M","orderNum":5,"params":{},"parentId":0,"path":"factoryeva","status":"0","visible":"0"}', NULL, N'1', N'nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property=''menuName'', mode=IN, javaType=class java.lang.String, jdbcType=null, numericScale=null, resultMapId=''null'', jdbcTypeName=''null'', expression=''null''}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #3 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 索引 3 超出范围。', N'2024-08-13 16:58:28', N'31')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'11', N'菜单管理', N'1', N'com.jack.web.controller.system.SysMenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"icon":"form","isCache":"0","isFrame":"1","menuName":"FactoryEvaluation","menuType":"M","orderNum":5,"params":{},"parentId":0,"path":"factoryeva","status":"0","visible":"0"}', NULL, N'1', N'nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property=''menuName'', mode=IN, javaType=class java.lang.String, jdbcType=null, numericScale=null, resultMapId=''null'', jdbcTypeName=''null'', expression=''null''}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #3 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 索引 3 超出范围。', N'2024-08-13 16:59:19', N'1')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'12', N'菜单管理', N'1', N'com.jack.web.controller.system.SysMenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"icon":"button","isCache":"0","isFrame":"1","menuName":"测试","menuType":"M","orderNum":9,"params":{},"parentId":0,"path":"test","status":"0","visible":"0"}', NULL, N'1', N'nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property=''menuName'', mode=IN, javaType=class java.lang.String, jdbcType=null, numericScale=null, resultMapId=''null'', jdbcTypeName=''null'', expression=''null''}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #3 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 索引 3 超出范围。', N'2024-08-13 17:10:55', N'1')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'13', N'菜单管理', N'1', N'com.jack.web.controller.system.SysMenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"icon":"button","isCache":"0","isFrame":"1","menuName":"测试","menuType":"M","orderNum":9,"params":{},"parentId":0,"path":"test","status":"0","visible":"0"}', NULL, N'1', N'nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property=''menuName'', mode=IN, javaType=class java.lang.String, jdbcType=null, numericScale=null, resultMapId=''null'', jdbcTypeName=''null'', expression=''null''}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #3 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 索引 3 超出范围。', N'2024-08-13 17:11:00', N'2')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'14', N'菜单管理', N'1', N'com.jack.web.controller.system.SysMenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"icon":"button","isCache":"0","isFrame":"1","menuName":"测试","menuType":"M","orderNum":9,"params":{},"parentId":0,"path":"test","status":"0","visible":"0"}', NULL, N'1', N'nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property=''menuName'', mode=IN, javaType=class java.lang.String, jdbcType=null, numericScale=null, resultMapId=''null'', jdbcTypeName=''null'', expression=''null''}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #3 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 索引 3 超出范围。', N'2024-08-13 17:11:04', N'2')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'15', N'菜单管理', N'1', N'com.jack.web.controller.system.SysMenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"icon":"button","isCache":"0","isFrame":"1","menuName":"测试","menuType":"M","orderNum":9,"params":{},"parentId":0,"path":"test","status":"0","visible":"0"}', NULL, N'1', N'nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property=''menuName'', mode=IN, javaType=class java.lang.String, jdbcType=null, numericScale=null, resultMapId=''null'', jdbcTypeName=''null'', expression=''null''}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #3 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 索引 3 超出范围。', N'2024-08-13 17:11:08', N'2')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'16', N'菜单管理', N'1', N'com.jack.web.controller.system.SysMenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"icon":"button","isCache":"0","isFrame":"1","menuName":"测试","menuType":"M","orderNum":9,"params":{},"parentId":0,"path":"test","status":"0","visible":"0"}', NULL, N'1', N'nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property=''menuName'', mode=IN, javaType=class java.lang.String, jdbcType=null, numericScale=null, resultMapId=''null'', jdbcTypeName=''null'', expression=''null''}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #3 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: com.microsoft.sqlserver.jdbc.SQLServerException: 索引 3 超出范围。', N'2024-08-13 17:21:43', N'25')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'17', N'菜单管理', N'1', N'com.jack.web.controller.system.SysMenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"createBy":"admin","icon":"button","isCache":"0","isFrame":"1","menuName":"test","menuType":"M","orderNum":5,"params":{},"parentId":0,"path":"test","status":"0","visible":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-13 17:23:34', N'112')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'18', N'菜单管理', N'2', N'com.jack.web.controller.system.SysMenuController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"createTime":"2024-08-13 17:23:34","icon":"form","isCache":"0","isFrame":"1","menuId":1061,"menuName":"Factory Evaluation","menuType":"M","orderNum":5,"params":{},"parentId":0,"path":"factoryeva","perms":"","routeName":"","status":"0","updateBy":"admin","visible":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-13 17:25:59', N'87')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'19', N'代码生成', N'6', N'com.jack.generator.controller.GenController.importTableSave()', N'POST', N'1', N'admin', N'????', N'/tool/gen/importTable', N'127.0.0.1', N'内网IP', N'{"tables":"sys_config"}', NULL, N'1', N'导入失败：
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ''&''.
### The error may exist in file [D:\myIdea\contempo\qc_2024\qc_server\qc-generator\target\classes\mapper\generator\GenTableColumnMapper.xml]
### The error may involve com.jack.generator.mapper.GenTableColumnMapper.selectDbTableColumnsByName-Inline
### The error occurred while setting parameters
### SQL: select column_name, (case when (is_nullable = ''no''   &&   column_key != ''PRI'') then ''1'' else ''0'' end) as is_required, (case when column_key = ''PRI'' then ''1'' else ''0'' end) as is_pk, ordinal_position as sort, column_comment, (case when extra = ''auto_increment'' then ''1'' else ''0'' end) as is_increment, column_type   from information_schema.columns where table_schema = (select database()) and table_name = (?)   order by ordinal_position
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ''&''.
; uncategorized SQLException; SQL state [S0001]; error code [102]; Incorrect syntax near ''&''.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ''&''.', N'2024-08-14 12:04:51', N'314')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'20', N'代码生成', N'6', N'com.jack.generator.controller.GenController.importTableSave()', N'POST', N'1', N'admin', N'????', N'/tool/gen/importTable', N'127.0.0.1', N'内网IP', N'{"tables":"sys_role"}', NULL, N'1', N'导入失败：
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ''&''.
### The error may exist in file [D:\myIdea\contempo\qc_2024\qc_server\qc-generator\target\classes\mapper\generator\GenTableColumnMapper.xml]
### The error may involve com.jack.generator.mapper.GenTableColumnMapper.selectDbTableColumnsByName-Inline
### The error occurred while setting parameters
### SQL: select column_name, (case when (is_nullable = ''no''   &&   column_key != ''PRI'') then ''1'' else ''0'' end) as is_required, (case when column_key = ''PRI'' then ''1'' else ''0'' end) as is_pk, ordinal_position as sort, column_comment, (case when extra = ''auto_increment'' then ''1'' else ''0'' end) as is_increment, column_type   from information_schema.columns where table_schema = (select database()) and table_name = (?)   order by ordinal_position
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ''&''.
; uncategorized SQLException; SQL state [S0001]; error code [102]; Incorrect syntax near ''&''.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ''&''.', N'2024-08-14 12:05:52', N'175')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'21', N'代码生成', N'6', N'com.jack.generator.controller.GenController.importTableSave()', N'POST', N'1', N'admin', N'研发部门', N'/tool/gen/importTable', N'127.0.0.1', N'内网IP', N'{"tables":"tb_fe_test"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-14 14:19:02', N'105')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'22', N'代码生成', N'6', N'com.jack.generator.controller.GenController.importTableSave()', N'POST', N'1', N'admin', N'研发部门', N'/tool/gen/importTable', N'127.0.0.1', N'内网IP', N'{"tables":"tb_fe_menu"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-14 14:19:18', N'47')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'23', N'代码生成', N'6', N'com.jack.generator.controller.GenController.importTableSave()', N'POST', N'1', N'admin', N'研发部门', N'/tool/gen/importTable', N'127.0.0.1', N'内网IP', N'{"tables":"tb_fe_menu"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-14 14:20:11', N'88')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'24', N'代码生成', N'6', N'com.jack.generator.controller.GenController.importTableSave()', N'POST', N'1', N'admin', N'研发部门', N'/tool/gen/importTable', N'127.0.0.1', N'内网IP', N'{"tables":"sys_config"}', NULL, N'1', N'导入失败：
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ''&''.
### The error may exist in file [D:\myIdea\contempo\qc_2024\qc_server\qc-generator\target\classes\mapper\generator\GenTableColumnMapper.xml]
### The error may involve com.jack.generator.mapper.GenTableColumnMapper.selectDbTableColumnsByName-Inline
### The error occurred while setting parameters
### SQL: select column_name, (case when (is_nullable = ''no''   &&   column_key != ''PRI'') then ''1'' else ''0'' end) as is_required, (case when column_key = ''PRI'' then ''1'' else ''0'' end) as is_pk, ordinal_position as sort, column_comment, (case when extra = ''auto_increment'' then ''1'' else ''0'' end) as is_increment, column_type   from information_schema.columns where table_schema = (select database()) and table_name = (?)   order by ordinal_position
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ''&''.
; uncategorized SQLException; SQL state [S0001]; error code [102]; Incorrect syntax near ''&''.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ''&''.', N'2024-08-14 14:28:16', N'126')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'25', N'代码生成', N'6', N'com.jack.generator.controller.GenController.importTableSave()', N'POST', N'1', N'admin', N'研发部门', N'/tool/gen/importTable', N'127.0.0.1', N'内网IP', N'{"tables":"sys_config"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-14 14:30:55', N'507')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'26', N'代码生成', N'8', N'com.jack.generator.controller.GenController.batchGenCode()', N'GET', N'1', N'admin', N'研发部门', N'/tool/gen/batchGenCode', N'127.0.0.1', N'内网IP', N'{"tables":"sys_config"}', NULL, N'0', NULL, N'2024-08-14 14:31:36', N'625')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'27', N'代码生成', N'6', N'com.jack.generator.controller.GenController.importTableSave()', N'POST', N'1', N'admin', N'研发部门', N'/tool/gen/importTable', N'127.0.0.1', N'内网IP', N'{"tables":"tb_user"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-14 14:59:39', N'851')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'28', N'代码生成', N'2', N'com.jack.generator.controller.GenController.editSave()', N'PUT', N'1', N'admin', N'研发部门', N'/tool/gen', N'127.0.0.1', N'内网IP', N'{"businessName":"user","className":"TbUser","columns":[{"capJavaField":"Id","columnComment":"user id","columnId":11,"columnName":"id","columnType":"int","createBy":"admin","createTime":"2024-08-14 14:59:38","dictType":"","edit":false,"htmlType":"input","increment":true,"insert":true,"isIncrement":"1","isInsert":"1","isPk":"1","isRequired":"1","javaField":"id","javaType":"Long","list":false,"params":{},"pk":true,"query":false,"queryType":"EQ","required":true,"sort":1,"superColumn":false,"tableId":5,"updateBy":"","usableColumn":false},{"capJavaField":"Name","columnComment":"user name","columnId":12,"columnName":"name","columnType":"varchar","createBy":"admin","createTime":"2024-08-14 14:59:38","dictType":"","edit":true,"htmlType":"input","increment":false,"insert":true,"isEdit":"1","isIncrement":"0","isInsert":"1","isList":"1","isPk":"0","isQuery":"1","isRequired":"0","javaField":"name","javaType":"String","list":true,"params":{},"pk":false,"query":true,"queryType":"LIKE","required":false,"sort":2,"superColumn":false,"tableId":5,"updateBy":"","usableColumn":false},{"capJavaField":"Age","columnComment":"user age","columnId":13,"columnName":"age","columnType":"int","createBy":"admin","createTime":"2024-08-14 14:59:38","dictType":"","edit":true,"htmlType":"input","increment":false,"insert":true,"isEdit":"1","isIncrement":"0","isInsert":"1","isList":"1","isPk":"0","isQuery":"1","isRequired":"0","javaField":"age","javaType":"Long","list":true,"params":{},"pk":false,"query":true,"queryType":"EQ","required":false,"sort":3,"superColumn":false,"tableId":5,"updateBy":"","usableColumn":false}],"crud":true,"functionAuthor":"ruoyi","functionName":"table test","genPath":"/","genType":"0","moduleName":"system","options":"{\"parentMenuId\":\"\"}","packageName":"com.jack.system","params":{"parentMenuId":""},"parentMenuId":"","sub":false,"tableComment":"table test","tableId":5,"tableName":"tb_user","tplCategory":"crud","tplWebType":"element-plus","tree":false}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-14 15:28:24', N'265')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'29', N'代码生成', N'8', N'com.jack.generator.controller.GenController.batchGenCode()', N'GET', N'1', N'admin', N'研发部门', N'/tool/gen/batchGenCode', N'127.0.0.1', N'内网IP', N'{"tables":"tb_user"}', NULL, N'0', NULL, N'2024-08-14 15:28:31', N'98')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'30', N'代码生成', N'6', N'com.jack.generator.controller.GenController.importTableSave()', N'POST', N'1', N'admin', N'研发部门', N'/tool/gen/importTable', N'127.0.0.1', N'内网IP', N'{"tables":"tb_fe_menu"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 10:26:48', N'550')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'31', N'代码生成', N'2', N'com.jack.generator.controller.GenController.editSave()', N'PUT', N'1', N'admin', N'研发部门', N'/tool/gen', N'127.0.0.1', N'内网IP', N'{"businessName":"menu","className":"FeMenu","columns":[{"capJavaField":"MenuId","columnComment":"Menu Id","columnId":14,"columnName":"menu_id","columnType":"int","createBy":"admin","createTime":"2024-08-28 10:26:47","dictType":"","edit":false,"htmlType":"input","increment":true,"insert":true,"isEdit":"0","isIncrement":"1","isInsert":"1","isList":"0","isPk":"0","isQuery":"0","isRequired":"1","javaField":"menuId","javaType":"Long","list":false,"params":{},"pk":false,"query":false,"queryType":"EQ","required":true,"sort":1,"superColumn":false,"tableId":6,"updateBy":"","usableColumn":false},{"capJavaField":"MenuType","columnComment":"Menu Type","columnId":15,"columnName":"menu_type","columnType":"int","createBy":"admin","createTime":"2024-08-28 10:26:47","dictType":"","edit":true,"htmlType":"select","increment":false,"insert":true,"isEdit":"1","isIncrement":"0","isInsert":"1","isList":"1","isPk":"0","isQuery":"1","isRequired":"1","javaField":"menuType","javaType":"Long","list":true,"params":{},"pk":false,"query":true,"queryType":"EQ","required":true,"sort":2,"superColumn":false,"tableId":6,"updateBy":"","usableColumn":false},{"capJavaField":"MenuNameEn","columnComment":"Menu Name English","columnId":16,"columnName":"menu_name_en","columnType":"nvarchar","createBy":"admin","createTime":"2024-08-28 10:26:47","dictType":"","edit":true,"htmlType":"input","increment":false,"insert":true,"isEdit":"1","isIncrement":"0","isInsert":"1","isList":"1","isPk":"0","isQuery":"1","isRequired":"1","javaField":"menuNameEn","javaType":"String","list":true,"params":{},"pk":false,"query":true,"queryType":"EQ","required":true,"sort":3,"superColumn":false,"tableId":6,"updateBy":"","usableColumn":false},{"capJavaField":"MenuNameZh","columnComment":"Menu Name Chinese","columnId":17,"columnName":"menu_name_zh","columnType":"nvarchar","createBy":"admin","createTime":"2024-08-28 10:26:47","dictType":"","edit":true,"htmlType":"input","increment":false,"insert":true,"isEdit":"1","isIncrement":"0","is', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 10:36:01', N'278')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'32', N'字典类型', N'1', N'com.jack.web.controller.system.SysDictTypeController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/dict/type', N'127.0.0.1', N'内网IP', N'{"dictName":"FeMenuType","dictType":"fe_menu_type","params":{},"remark":"Factory Evaluation Menu Type","status":"0"}', NULL, N'1', N'
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.
### The error may exist in file [D:\myIdea\contempo\qc_2024\qc_server\qc-system\target\classes\mapper\system\SysDictTypeMapper.xml]
### The error may involve com.jack.system.mapper.SysDictTypeMapper.checkDictTypeUnique-Inline
### The error occurred while setting parameters
### SQL: select dict_id, dict_name, dict_type, status, create_by, create_time, remark   from sys_dict_type         where dict_type = ? top 1
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.
; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.', N'2024-08-28 10:46:19', N'106')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'33', N'字典类型', N'1', N'com.jack.web.controller.system.SysDictTypeController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/dict/type', N'127.0.0.1', N'内网IP', N'{"dictName":"FeMenuType","dictType":"fe_menu_type","params":{},"remark":"Factory Evaluation Menu Type","status":"0"}', NULL, N'1', N'
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.
### The error may exist in file [D:\myIdea\contempo\qc_2024\qc_server\qc-system\target\classes\mapper\system\SysDictTypeMapper.xml]
### The error may involve com.jack.system.mapper.SysDictTypeMapper.checkDictTypeUnique-Inline
### The error occurred while setting parameters
### SQL: select dict_id, dict_name, dict_type, status, create_by, create_time, remark   from sys_dict_type         where dict_type = ? top 1
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.
; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.', N'2024-08-28 10:46:25', N'13')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'34', N'字典类型', N'1', N'com.jack.web.controller.system.SysDictTypeController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/dict/type', N'127.0.0.1', N'内网IP', N'{"dictName":"FeMenuType","dictType":"fe_menu_type","params":{},"remark":"Factory Evaluation Menu Type","status":"0"}', NULL, N'1', N'
### Error querying database.  Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.
### The error may exist in file [D:\myIdea\contempo\qc_2024\qc_server\qc-system\target\classes\mapper\system\SysDictTypeMapper.xml]
### The error may involve com.jack.system.mapper.SysDictTypeMapper.checkDictTypeUnique-Inline
### The error occurred while setting parameters
### SQL: select dict_id, dict_name, dict_type, status, create_by, create_time, remark   from sys_dict_type         where dict_type = ? top 1
### Cause: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.
; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ''top''.', N'2024-08-28 10:46:29', N'109')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'35', N'字典类型', N'1', N'com.jack.web.controller.system.SysDictTypeController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/dict/type', N'127.0.0.1', N'内网IP', N'{"createBy":"admin","dictName":"FeMenuType","dictType":"fe_menu_type","params":{},"remark":"Factory Evaluation Menu Type","status":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 10:50:15', N'114')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'36', N'字典数据', N'1', N'com.jack.web.controller.system.SysDictDataController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/dict/data', N'127.0.0.1', N'内网IP', N'{"createBy":"admin","default":false,"dictLabel":"Section","dictSort":1,"dictType":"fe_menu_type","dictValue":"0","listClass":"default","params":{},"status":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 11:35:25', N'55')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'37', N'字典数据', N'1', N'com.jack.web.controller.system.SysDictDataController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/dict/data', N'127.0.0.1', N'内网IP', N'{"createBy":"admin","default":false,"dictLabel":"Question","dictSort":2,"dictType":"fe_menu_type","dictValue":"1","listClass":"default","params":{},"status":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 11:35:41', N'50')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'38', N'字典数据', N'1', N'com.jack.web.controller.system.SysDictDataController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/dict/data', N'127.0.0.1', N'内网IP', N'{"createBy":"admin","default":false,"dictLabel":"Rate","dictSort":3,"dictType":"fe_menu_type","dictValue":"2","listClass":"default","params":{},"status":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 11:35:58', N'1180')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'39', N'代码生成', N'2', N'com.jack.generator.controller.GenController.editSave()', N'PUT', N'1', N'admin', N'研发部门', N'/tool/gen', N'127.0.0.1', N'内网IP', N'{"businessName":"menu","className":"FeMenu","columns":[{"capJavaField":"MenuId","columnComment":"Menu Id","columnId":14,"columnName":"menu_id","columnType":"int","createBy":"admin","createTime":"2024-08-28 10:26:47","dictType":"","edit":false,"htmlType":"input","increment":true,"insert":true,"isEdit":"0","isIncrement":"1","isInsert":"1","isList":"0","isPk":"0","isQuery":"0","isRequired":"1","javaField":"menuId","javaType":"Long","list":false,"params":{},"pk":false,"query":false,"queryType":"EQ","required":true,"sort":1,"superColumn":false,"tableId":6,"updateBy":"","updateTime":"2024-08-28 10:36:00","usableColumn":false},{"capJavaField":"MenuType","columnComment":"Menu Type","columnId":15,"columnName":"menu_type","columnType":"int","createBy":"admin","createTime":"2024-08-28 10:26:47","dictType":"fe_menu_type","edit":true,"htmlType":"select","increment":false,"insert":true,"isEdit":"1","isIncrement":"0","isInsert":"1","isList":"1","isPk":"0","isQuery":"1","isRequired":"1","javaField":"menuType","javaType":"Long","list":true,"params":{},"pk":false,"query":true,"queryType":"EQ","required":true,"sort":2,"superColumn":false,"tableId":6,"updateBy":"","updateTime":"2024-08-28 10:36:00","usableColumn":false},{"capJavaField":"MenuNameEn","columnComment":"Menu Name English","columnId":16,"columnName":"menu_name_en","columnType":"nvarchar","createBy":"admin","createTime":"2024-08-28 10:26:47","dictType":"","edit":true,"htmlType":"input","increment":false,"insert":true,"isEdit":"1","isIncrement":"0","isInsert":"1","isList":"1","isPk":"0","isQuery":"1","isRequired":"1","javaField":"menuNameEn","javaType":"String","list":true,"params":{},"pk":false,"query":true,"queryType":"EQ","required":true,"sort":3,"superColumn":false,"tableId":6,"updateBy":"","updateTime":"2024-08-28 10:36:00","usableColumn":false},{"capJavaField":"MenuNameZh","columnComment":"Menu Name Chinese","columnId":17,"columnName":"menu_name_zh","columnType":"nvarchar","createBy":"admin","createTime":"2024-08-28 10:2', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 11:40:38', N'491')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'40', N'字典类型', N'1', N'com.jack.web.controller.system.SysDictTypeController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/dict/type', N'127.0.0.1', N'内网IP', N'{"createBy":"admin","dictName":"FeStatus","dictType":"fe_status","params":{},"status":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 11:42:04', N'281')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'41', N'字典数据', N'1', N'com.jack.web.controller.system.SysDictDataController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/dict/data', N'127.0.0.1', N'内网IP', N'{"createBy":"admin","default":false,"dictLabel":"inactive","dictSort":1,"dictType":"fe_status","dictValue":"0","listClass":"default","params":{},"status":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 11:42:43', N'286')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'42', N'字典数据', N'1', N'com.jack.web.controller.system.SysDictDataController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/dict/data', N'127.0.0.1', N'内网IP', N'{"createBy":"admin","default":false,"dictLabel":"active","dictSort":2,"dictType":"fe_status","dictValue":"1","listClass":"default","params":{},"status":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 11:42:55', N'49')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'43', N'代码生成', N'2', N'com.jack.generator.controller.GenController.editSave()', N'PUT', N'1', N'admin', N'研发部门', N'/tool/gen', N'127.0.0.1', N'内网IP', N'{"businessName":"menu","className":"FeMenu","columns":[{"capJavaField":"MenuId","columnComment":"Menu Id","columnId":14,"columnName":"menu_id","columnType":"int","createBy":"admin","createTime":"2024-08-28 10:26:47","dictType":"","edit":false,"htmlType":"input","increment":true,"insert":false,"isEdit":"0","isIncrement":"1","isInsert":"0","isList":"0","isPk":"0","isQuery":"0","isRequired":"0","javaField":"menuId","javaType":"Long","list":false,"params":{},"pk":false,"query":false,"queryType":"EQ","required":false,"sort":1,"superColumn":false,"tableId":6,"updateBy":"","updateTime":"2024-08-28 11:40:37","usableColumn":false},{"capJavaField":"MenuType","columnComment":"Menu Type","columnId":15,"columnName":"menu_type","columnType":"int","createBy":"admin","createTime":"2024-08-28 10:26:47","dictType":"fe_menu_type","edit":true,"htmlType":"select","increment":false,"insert":true,"isEdit":"1","isIncrement":"0","isInsert":"1","isList":"1","isPk":"0","isQuery":"1","isRequired":"1","javaField":"menuType","javaType":"Long","list":true,"params":{},"pk":false,"query":true,"queryType":"EQ","required":true,"sort":2,"superColumn":false,"tableId":6,"updateBy":"","updateTime":"2024-08-28 11:40:37","usableColumn":false},{"capJavaField":"MenuNameEn","columnComment":"Menu Name English","columnId":16,"columnName":"menu_name_en","columnType":"nvarchar","createBy":"admin","createTime":"2024-08-28 10:26:47","dictType":"","edit":true,"htmlType":"input","increment":false,"insert":true,"isEdit":"1","isIncrement":"0","isInsert":"1","isList":"1","isPk":"0","isQuery":"1","isRequired":"1","javaField":"menuNameEn","javaType":"String","list":true,"params":{},"pk":false,"query":true,"queryType":"EQ","required":true,"sort":3,"superColumn":false,"tableId":6,"updateBy":"","updateTime":"2024-08-28 11:40:37","usableColumn":false},{"capJavaField":"MenuNameZh","columnComment":"Menu Name Chinese","columnId":17,"columnName":"menu_name_zh","columnType":"nvarchar","createBy":"admin","createTime":"2024-08-28 10', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 12:10:05', N'377')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'44', N'代码生成', N'8', N'com.jack.generator.controller.GenController.batchGenCode()', N'GET', N'1', N'admin', N'研发部门', N'/tool/gen/batchGenCode', N'127.0.0.1', N'内网IP', N'{"tables":"tb_fe_menu"}', NULL, N'0', NULL, N'2024-08-28 14:17:59', N'808')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'45', N'菜单管理', N'2', N'com.jack.web.controller.system.SysMenuController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"component":"system/menu/index","createTime":"2024-06-29 20:09:44","icon":"tree-table","isCache":"0","isFrame":"1","menuId":102,"menuName":"菜单管理","menuType":"C","orderNum":3,"params":{},"parentId":1,"path":"menu","perms":"system:menu:list","query":"","routeName":"","status":"0","updateBy":"admin","visible":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 15:28:04', N'101')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'46', N'菜单管理', N'2', N'com.jack.web.controller.system.SysMenuController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"createTime":"2024-08-13 17:23:34","icon":"form","isCache":"0","isFrame":"1","menuId":1061,"menuName":"Factory Evaluation","menuType":"M","orderNum":5,"params":{},"parentId":0,"path":"factoryeva","perms":"","routeName":"","status":"0","updateBy":"admin","visible":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 15:28:36', N'110')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'47', N'代码生成', N'2', N'com.jack.generator.controller.GenController.editSave()', N'PUT', N'1', N'admin', N'研发部门', N'/tool/gen', N'127.0.0.1', N'内网IP', N'{"businessName":"user","className":"TbUser","columns":[{"capJavaField":"Id","columnComment":"user id","columnId":11,"columnName":"id","columnType":"int","createBy":"admin","createTime":"2024-08-14 14:59:38","dictType":"","edit":false,"htmlType":"input","increment":true,"insert":true,"isIncrement":"1","isInsert":"1","isPk":"1","isRequired":"1","javaField":"id","javaType":"Long","list":false,"params":{},"pk":true,"query":false,"queryType":"EQ","required":true,"sort":1,"superColumn":false,"tableId":5,"updateBy":"","updateTime":"2024-08-14 15:28:24","usableColumn":false},{"capJavaField":"Name","columnComment":"user name","columnId":12,"columnName":"name","columnType":"varchar","createBy":"admin","createTime":"2024-08-14 14:59:38","dictType":"","edit":true,"htmlType":"input","increment":false,"insert":true,"isEdit":"1","isIncrement":"0","isInsert":"1","isList":"1","isPk":"0","isQuery":"1","isRequired":"0","javaField":"name","javaType":"String","list":true,"params":{},"pk":false,"query":true,"queryType":"LIKE","required":false,"sort":2,"superColumn":false,"tableId":5,"updateBy":"","updateTime":"2024-08-14 15:28:24","usableColumn":false},{"capJavaField":"Age","columnComment":"user age","columnId":13,"columnName":"age","columnType":"int","createBy":"admin","createTime":"2024-08-14 14:59:38","dictType":"","edit":true,"htmlType":"input","increment":false,"insert":true,"isEdit":"1","isIncrement":"0","isInsert":"1","isList":"1","isPk":"0","isQuery":"1","isRequired":"0","javaField":"age","javaType":"Long","list":true,"params":{},"pk":false,"query":true,"queryType":"EQ","required":false,"sort":3,"superColumn":false,"tableId":5,"updateBy":"","updateTime":"2024-08-14 15:28:24","usableColumn":false}],"crud":true,"functionAuthor":"ruoyi","functionName":"table test","genPath":"/","genType":"0","moduleName":"system","options":"{\"parentMenuId\":\"\"}","packageName":"com.jack.system","params":{"parentMenuId":""},"parentMenuId":"","sub":false,"tableComment":"table test","tableId":5,"tabl', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 16:15:56', N'235')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'48', N'代码生成', N'8', N'com.jack.generator.controller.GenController.batchGenCode()', N'GET', N'1', N'admin', N'研发部门', N'/tool/gen/batchGenCode', N'127.0.0.1', N'内网IP', N'{"tables":"tb_user"}', NULL, N'0', NULL, N'2024-08-28 16:16:02', N'1150')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'49', N'代码生成', N'6', N'com.jack.generator.controller.GenController.importTableSave()', N'POST', N'1', N'admin', N'研发部门', N'/tool/gen/importTable', N'127.0.0.1', N'内网IP', N'{"tables":"tb_femenu"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 16:44:40', N'559')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'50', N'代码生成', N'2', N'com.jack.generator.controller.GenController.editSave()', N'PUT', N'1', N'admin', N'研发部门', N'/tool/gen', N'127.0.0.1', N'内网IP', N'{"businessName":"femenu","className":"Femenu","columns":[{"capJavaField":"MenuId","columnComment":"Menu Id","columnId":28,"columnName":"menu_id","columnType":"int","createBy":"admin","createTime":"2024-08-28 16:44:39","dictType":"","edit":true,"htmlType":"input","increment":true,"insert":true,"isEdit":"1","isIncrement":"1","isInsert":"1","isList":"1","isPk":"0","isQuery":"1","isRequired":"1","javaField":"menuId","javaType":"Long","list":true,"params":{},"pk":false,"query":true,"queryType":"EQ","required":true,"sort":1,"superColumn":false,"tableId":7,"updateBy":"","usableColumn":false},{"capJavaField":"MenuType","columnComment":"Menu Type","columnId":29,"columnName":"menu_type","columnType":"int","createBy":"admin","createTime":"2024-08-28 16:44:39","dictType":"","edit":true,"htmlType":"select","increment":false,"insert":true,"isEdit":"1","isIncrement":"0","isInsert":"1","isList":"1","isPk":"0","isQuery":"1","isRequired":"1","javaField":"menuType","javaType":"Long","list":true,"params":{},"pk":false,"query":true,"queryType":"EQ","required":true,"sort":2,"superColumn":false,"tableId":7,"updateBy":"","usableColumn":false},{"capJavaField":"MenuNameEn","columnComment":"Menu Name English","columnId":30,"columnName":"menu_name_en","columnType":"nvarchar","createBy":"admin","createTime":"2024-08-28 16:44:39","dictType":"","edit":true,"htmlType":"input","increment":false,"insert":true,"isEdit":"1","isIncrement":"0","isInsert":"1","isList":"1","isPk":"0","isQuery":"1","isRequired":"1","javaField":"menuNameEn","javaType":"String","list":true,"params":{},"pk":false,"query":true,"queryType":"EQ","required":true,"sort":3,"superColumn":false,"tableId":7,"updateBy":"","usableColumn":false},{"capJavaField":"MenuNameZh","columnComment":"Menu Name Chinese","columnId":31,"columnName":"menu_name_zh","columnType":"nvarchar","createBy":"admin","createTime":"2024-08-28 16:44:39","dictType":"","edit":true,"htmlType":"input","increment":false,"insert":true,"isEdit":"1","isIncrement":"0","isI', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 16:45:07', N'247')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'51', N'代码生成', N'2', N'com.jack.generator.controller.GenController.editSave()', N'PUT', N'1', N'admin', N'研发部门', N'/tool/gen', N'127.0.0.1', N'内网IP', N'{"businessName":"femenu","className":"Femenu","columns":[{"capJavaField":"MenuId","columnComment":"Menu Id","columnId":28,"columnName":"menu_id","columnType":"int","createBy":"admin","createTime":"2024-08-28 16:44:39","dictType":"","edit":false,"htmlType":"input","increment":true,"insert":false,"isEdit":"0","isIncrement":"1","isInsert":"0","isList":"0","isPk":"0","isQuery":"0","isRequired":"0","javaField":"menuId","javaType":"Long","list":false,"params":{},"pk":false,"query":false,"queryType":"EQ","required":false,"sort":1,"superColumn":false,"tableId":7,"updateBy":"","updateTime":"2024-08-28 16:45:07","usableColumn":false},{"capJavaField":"MenuType","columnComment":"Menu Type","columnId":29,"columnName":"menu_type","columnType":"int","createBy":"admin","createTime":"2024-08-28 16:44:39","dictType":"fe_menu_type","edit":true,"htmlType":"select","increment":false,"insert":true,"isEdit":"1","isIncrement":"0","isInsert":"1","isList":"1","isPk":"0","isQuery":"1","isRequired":"1","javaField":"menuType","javaType":"Long","list":true,"params":{},"pk":false,"query":true,"queryType":"EQ","required":true,"sort":2,"superColumn":false,"tableId":7,"updateBy":"","updateTime":"2024-08-28 16:45:07","usableColumn":false},{"capJavaField":"MenuNameEn","columnComment":"Menu Name English","columnId":30,"columnName":"menu_name_en","columnType":"nvarchar","createBy":"admin","createTime":"2024-08-28 16:44:39","dictType":"","edit":true,"htmlType":"input","increment":false,"insert":true,"isEdit":"1","isIncrement":"0","isInsert":"1","isList":"1","isPk":"0","isQuery":"1","isRequired":"1","javaField":"menuNameEn","javaType":"String","list":true,"params":{},"pk":false,"query":true,"queryType":"EQ","required":true,"sort":3,"superColumn":false,"tableId":7,"updateBy":"","updateTime":"2024-08-28 16:45:07","usableColumn":false},{"capJavaField":"MenuNameZh","columnComment":"Menu Name Chinese","columnId":31,"columnName":"menu_name_zh","columnType":"nvarchar","createBy":"admin","createTime":"2024-08-28 ', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 16:48:33', N'259')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'52', N'代码生成', N'2', N'com.jack.generator.controller.GenController.editSave()', N'PUT', N'1', N'admin', N'研发部门', N'/tool/gen', N'127.0.0.1', N'内网IP', N'{"businessName":"femenu","className":"Femenu","columns":[{"capJavaField":"MenuId","columnComment":"Menu Id","columnId":28,"columnName":"menu_id","columnType":"int","createBy":"admin","createTime":"2024-08-28 16:44:39","dictType":"","edit":false,"htmlType":"input","increment":true,"insert":false,"isEdit":"0","isIncrement":"1","isInsert":"0","isList":"0","isPk":"0","isQuery":"0","isRequired":"0","javaField":"menuId","javaType":"Long","list":false,"params":{},"pk":false,"query":false,"queryType":"EQ","required":false,"sort":1,"superColumn":false,"tableId":7,"updateBy":"","updateTime":"2024-08-28 16:48:32","usableColumn":false},{"capJavaField":"MenuType","columnComment":"Menu Type","columnId":29,"columnName":"menu_type","columnType":"int","createBy":"admin","createTime":"2024-08-28 16:44:39","dictType":"fe_menu_type","edit":true,"htmlType":"select","increment":false,"insert":true,"isEdit":"1","isIncrement":"0","isInsert":"1","isList":"1","isPk":"0","isQuery":"1","isRequired":"1","javaField":"menuType","javaType":"Long","list":true,"params":{},"pk":false,"query":true,"queryType":"EQ","required":true,"sort":2,"superColumn":false,"tableId":7,"updateBy":"","updateTime":"2024-08-28 16:48:32","usableColumn":false},{"capJavaField":"MenuNameEn","columnComment":"Menu Name English","columnId":30,"columnName":"menu_name_en","columnType":"nvarchar","createBy":"admin","createTime":"2024-08-28 16:44:39","dictType":"","edit":true,"htmlType":"input","increment":false,"insert":true,"isEdit":"1","isIncrement":"0","isInsert":"1","isList":"1","isPk":"0","isQuery":"1","isRequired":"1","javaField":"menuNameEn","javaType":"String","list":true,"params":{},"pk":false,"query":true,"queryType":"EQ","required":true,"sort":3,"superColumn":false,"tableId":7,"updateBy":"","updateTime":"2024-08-28 16:48:32","usableColumn":false},{"capJavaField":"MenuNameZh","columnComment":"Menu Name Chinese","columnId":31,"columnName":"menu_name_zh","columnType":"nvarchar","createBy":"admin","createTime":"2024-08-28 ', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 16:50:16', N'359')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'53', N'代码生成', N'8', N'com.jack.generator.controller.GenController.batchGenCode()', N'GET', N'1', N'admin', N'研发部门', N'/tool/gen/batchGenCode', N'127.0.0.1', N'内网IP', N'{"tables":"tb_femenu"}', NULL, N'0', NULL, N'2024-08-28 16:50:20', N'294')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'54', N'Factory Evaluation Menu', N'1', N'com.jack.qcfe.controller.FemenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/fe/femenu', N'127.0.0.1', N'内网IP', N'{"children":[],"createTime":"2024-08-28 17:19:40","menuDeleted":0,"menuDisplayOrder":1,"menuId":1,"menuNameEn":"QAQC system","menuNameZh":"QAQC 系统","menuParentId":0,"menuStatus":1,"menuType":0,"params":{}}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 17:19:40', N'145')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'55', N'Factory Evaluation Menu', N'1', N'com.jack.qcfe.controller.FemenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/fe/femenu', N'127.0.0.1', N'内网IP', N'{"children":[],"createTime":"2024-08-28 17:21:20","menuDeleted":0,"menuDisplayOrder":1,"menuId":2,"menuNameEn":"Has factory set up independent QA/QC team?","menuNameZh":"工厂有否成立了独立的QA/QC团队？","menuParentId":1,"menuStatus":1,"menuType":1,"params":{}}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 17:21:21', N'77')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'56', N'菜单管理', N'1', N'com.jack.web.controller.system.SysMenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"createBy":"admin","icon":"tab","isCache":"0","isFrame":"1","menuName":"Factory Evaluation","menuType":"M","orderNum":5,"params":{},"parentId":0,"path":"fe","status":"0","visible":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 17:34:35', N'155')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'57', N'菜单管理', N'2', N'com.jack.web.controller.system.SysMenuController.edit()', N'PUT', N'1', N'admin', N'研发部门', N'/system/menu', N'127.0.0.1', N'内网IP', N'{"children":[],"component":"fe/femenu/index","createTime":"2024-08-28 16:52:30","icon":"education","isCache":"0","isFrame":"1","menuId":1063,"menuName":"Menu","menuType":"C","orderNum":1,"params":{},"parentId":1069,"path":"femenu","perms":"fe:femenu:list","status":"0","updateBy":"admin","visible":"0"}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 17:36:20', N'258')
GO

INSERT INTO [dbo].[sys_oper_log] ([oper_id], [title], [business_type], [method], [request_method], [operator_type], [oper_name], [dept_name], [oper_url], [oper_ip], [oper_location], [oper_param], [json_result], [status], [error_msg], [oper_time], [cost_time]) VALUES (N'58', N'Factory Evaluation Menu', N'1', N'com.jack.qcfe.controller.FemenuController.add()', N'POST', N'1', N'admin', N'研发部门', N'/fe/femenu', N'127.0.0.1', N'内网IP', N'{"children":[],"createTime":"2024-08-28 17:47:10","menuDeleted":0,"menuDisplayOrder":1,"menuId":3,"menuNameEn":"All QA/QC team in All sections is not reported to The production","menuNameZh":"所有部门的所有QA/QC团队不向生产部汇报.","menuParentId":2,"menuRate":4,"menuStatus":1,"menuType":2,"params":{}}', N'{"msg":"操作成功","code":200}', N'0', NULL, N'2024-08-28 17:47:10', N'44')
GO

SET IDENTITY_INSERT [dbo].[sys_oper_log] OFF
GO


-- ----------------------------
-- Table structure for sys_post
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_post]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_post]
GO

CREATE TABLE [dbo].[sys_post] (
  [post_id] bigint  IDENTITY(5,1) NOT NULL,
  [post_code] nvarchar(64) COLLATE Latin1_General_BIN  NOT NULL,
  [post_name] nvarchar(50) COLLATE Latin1_General_BIN  NOT NULL,
  [post_sort] int  NOT NULL,
  [status] nchar(1) COLLATE Latin1_General_BIN  NOT NULL,
  [create_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [create_time] datetime2(0) DEFAULT NULL NULL,
  [update_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [update_time] datetime2(0) DEFAULT NULL NULL,
  [remark] nvarchar(500) COLLATE Latin1_General_BIN DEFAULT NULL NULL
)
GO

ALTER TABLE [dbo].[sys_post] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_post
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_post] ON
GO

INSERT INTO [dbo].[sys_post] ([post_id], [post_code], [post_name], [post_sort], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1', N'ceo', N'董事长', N'1', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_post] ([post_id], [post_code], [post_name], [post_sort], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'2', N'se', N'项目经理', N'2', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_post] ([post_id], [post_code], [post_name], [post_sort], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'3', N'hr', N'人力资源', N'3', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

INSERT INTO [dbo].[sys_post] ([post_id], [post_code], [post_name], [post_sort], [status], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'4', N'user', N'普通员工', N'4', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'')
GO

SET IDENTITY_INSERT [dbo].[sys_post] OFF
GO


-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_role]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_role]
GO

CREATE TABLE [dbo].[sys_role] (
  [role_id] bigint  IDENTITY(3,1) NOT NULL,
  [role_name] nvarchar(30) COLLATE Latin1_General_BIN  NOT NULL,
  [role_key] nvarchar(100) COLLATE Latin1_General_BIN  NOT NULL,
  [role_sort] int  NOT NULL,
  [data_scope] nchar(1) COLLATE Latin1_General_BIN DEFAULT (N'1') NULL,
  [menu_check_strictly] smallint DEFAULT ((1)) NULL,
  [dept_check_strictly] smallint DEFAULT ((1)) NULL,
  [status] nchar(1) COLLATE Latin1_General_BIN  NOT NULL,
  [del_flag] nchar(1) COLLATE Latin1_General_BIN DEFAULT (N'0') NULL,
  [create_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [create_time] datetime2(0) DEFAULT NULL NULL,
  [update_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [update_time] datetime2(0) DEFAULT NULL NULL,
  [remark] nvarchar(500) COLLATE Latin1_General_BIN DEFAULT NULL NULL
)
GO

ALTER TABLE [dbo].[sys_role] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_role
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_role] ON
GO

INSERT INTO [dbo].[sys_role] ([role_id], [role_name], [role_key], [role_sort], [data_scope], [menu_check_strictly], [dept_check_strictly], [status], [del_flag], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1', N'超级管理员', N'admin', N'1', N'1', N'1', N'1', N'0', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'超级管理员')
GO

INSERT INTO [dbo].[sys_role] ([role_id], [role_name], [role_key], [role_sort], [data_scope], [menu_check_strictly], [dept_check_strictly], [status], [del_flag], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'2', N'普通角色', N'common', N'2', N'2', N'1', N'1', N'0', N'0', N'admin', N'2024-06-29 20:09:44', N'', NULL, N'普通角色')
GO

SET IDENTITY_INSERT [dbo].[sys_role] OFF
GO


-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_role_dept]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_role_dept]
GO

CREATE TABLE [dbo].[sys_role_dept] (
  [role_id] bigint  NOT NULL,
  [dept_id] bigint  NOT NULL
)
GO

ALTER TABLE [dbo].[sys_role_dept] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_role_dept
-- ----------------------------
INSERT INTO [dbo].[sys_role_dept] ([role_id], [dept_id]) VALUES (N'2', N'100')
GO

INSERT INTO [dbo].[sys_role_dept] ([role_id], [dept_id]) VALUES (N'2', N'101')
GO

INSERT INTO [dbo].[sys_role_dept] ([role_id], [dept_id]) VALUES (N'2', N'105')
GO


-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_role_menu]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_role_menu]
GO

CREATE TABLE [dbo].[sys_role_menu] (
  [role_id] bigint  NOT NULL,
  [menu_id] bigint  NOT NULL
)
GO

ALTER TABLE [dbo].[sys_role_menu] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'2')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'3')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'4')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'100')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'101')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'102')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'103')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'104')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'105')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'106')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'107')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'108')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'109')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'110')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'111')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'112')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'113')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'114')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'115')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'116')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'117')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'500')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'501')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1000')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1001')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1002')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1003')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1004')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1005')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1006')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1007')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1008')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1009')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1010')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1011')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1012')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1013')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1014')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1015')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1016')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1017')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1018')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1019')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1020')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1021')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1022')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1023')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1024')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1025')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1026')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1027')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1028')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1029')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1030')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1031')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1032')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1033')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1034')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1035')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1036')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1037')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1038')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1039')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1040')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1041')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1042')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1043')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1044')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1045')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1046')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1047')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1048')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1049')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1050')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1051')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1052')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1053')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1054')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1055')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1056')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1057')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1058')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1059')
GO

INSERT INTO [dbo].[sys_role_menu] ([role_id], [menu_id]) VALUES (N'2', N'1060')
GO


-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_user]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_user]
GO

CREATE TABLE [dbo].[sys_user] (
  [user_id] bigint  IDENTITY(3,1) NOT NULL,
  [dept_id] bigint DEFAULT NULL NULL,
  [user_name] nvarchar(30) COLLATE Latin1_General_BIN  NOT NULL,
  [nick_name] nvarchar(30) COLLATE Latin1_General_BIN  NOT NULL,
  [user_type] nvarchar(2) COLLATE Latin1_General_BIN DEFAULT (N'00') NULL,
  [email] nvarchar(50) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [phonenumber] nvarchar(11) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [sex] nchar(1) COLLATE Latin1_General_BIN DEFAULT (N'0') NULL,
  [avatar] nvarchar(100) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [password] nvarchar(100) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [status] nchar(1) COLLATE Latin1_General_BIN DEFAULT (N'0') NULL,
  [del_flag] nchar(1) COLLATE Latin1_General_BIN DEFAULT (N'0') NULL,
  [login_ip] nvarchar(128) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [login_date] datetime2(0) DEFAULT NULL NULL,
  [create_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [create_time] datetime2(0) DEFAULT NULL NULL,
  [update_by] nvarchar(64) COLLATE Latin1_General_BIN DEFAULT (N'') NULL,
  [update_time] datetime2(0) DEFAULT NULL NULL,
  [remark] nvarchar(500) COLLATE Latin1_General_BIN DEFAULT NULL NULL
)
GO

ALTER TABLE [dbo].[sys_user] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_user
-- ----------------------------
SET IDENTITY_INSERT [dbo].[sys_user] ON
GO

INSERT INTO [dbo].[sys_user] ([user_id], [dept_id], [user_name], [nick_name], [user_type], [email], [phonenumber], [sex], [avatar], [password], [status], [del_flag], [login_ip], [login_date], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'1', N'103', N'admin', N'若依', N'00', N'ry@163.com', N'15888888888', N'1', N'', N'$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', N'0', N'0', N'127.0.0.1', N'2024-10-11 17:27:39', N'admin', N'2024-06-29 20:09:43', N'', N'2024-10-11 17:27:40', N'管理员')
GO

INSERT INTO [dbo].[sys_user] ([user_id], [dept_id], [user_name], [nick_name], [user_type], [email], [phonenumber], [sex], [avatar], [password], [status], [del_flag], [login_ip], [login_date], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'2', N'105', N'ry', N'若依', N'00', N'ry@qq.com', N'15666666666', N'1', N'', N'$2a$10$7JB720yubVSZvUI0rEqK/.VqGOZTH.ulu33dHOiBE8ByOhJIrdAu2', N'0', N'0', N'127.0.0.1', N'2024-06-29 20:09:43', N'admin', N'2024-06-29 20:09:43', N'', NULL, N'测试员')
GO

INSERT INTO [dbo].[sys_user] ([user_id], [dept_id], [user_name], [nick_name], [user_type], [email], [phonenumber], [sex], [avatar], [password], [status], [del_flag], [login_ip], [login_date], [create_by], [create_time], [update_by], [update_time], [remark]) VALUES (N'3', N'100', N'jackcheng', N'jack', N'00', N'', N'', N'0', N'', N'$2a$10$Xj5mkwubUSegtOTR3T/daerQqLbD1FUPvGTpHciukid6hyQTeVpji', N'0', N'0', N'', NULL, N'admin', N'2024-07-05 15:04:36', N'admin', N'2024-07-05 15:04:57', NULL)
GO

SET IDENTITY_INSERT [dbo].[sys_user] OFF
GO


-- ----------------------------
-- Table structure for sys_user_post
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_user_post]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_user_post]
GO

CREATE TABLE [dbo].[sys_user_post] (
  [user_id] bigint  NOT NULL,
  [post_id] bigint  NOT NULL
)
GO

ALTER TABLE [dbo].[sys_user_post] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_user_post
-- ----------------------------
INSERT INTO [dbo].[sys_user_post] ([user_id], [post_id]) VALUES (N'1', N'1')
GO

INSERT INTO [dbo].[sys_user_post] ([user_id], [post_id]) VALUES (N'2', N'2')
GO

INSERT INTO [dbo].[sys_user_post] ([user_id], [post_id]) VALUES (N'3', N'2')
GO


-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sys_user_role]') AND type IN ('U'))
	DROP TABLE [dbo].[sys_user_role]
GO

CREATE TABLE [dbo].[sys_user_role] (
  [user_id] bigint  NOT NULL,
  [role_id] bigint  NOT NULL
)
GO

ALTER TABLE [dbo].[sys_user_role] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
INSERT INTO [dbo].[sys_user_role] ([user_id], [role_id]) VALUES (N'1', N'1')
GO

INSERT INTO [dbo].[sys_user_role] ([user_id], [role_id]) VALUES (N'2', N'2')
GO

INSERT INTO [dbo].[sys_user_role] ([user_id], [role_id]) VALUES (N'3', N'2')
GO


-- ----------------------------
-- Table structure for tb_fe_menu
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_fe_menu]') AND type IN ('U'))
	DROP TABLE [dbo].[tb_fe_menu]
GO

CREATE TABLE [dbo].[tb_fe_menu] (
  [menu_id] int  IDENTITY(1,1) NOT NULL,
  [menu_type] int  NOT NULL,
  [menu_name_en] nvarchar(300) COLLATE Latin1_General_BIN  NOT NULL,
  [menu_name_zh] nvarchar(300) COLLATE Latin1_General_BIN  NOT NULL,
  [menu_parent_id] int  NOT NULL,
  [menu_display_order] int  NOT NULL,
  [menu_rate] int  NULL,
  [menu_status] int DEFAULT ((1)) NOT NULL,
  [menu_deleted] int DEFAULT ((0)) NOT NULL,
  [create_time] datetime DEFAULT (getdate()) NULL,
  [update_time] datetime  NULL,
  [create_by] nvarchar(50) COLLATE Latin1_General_BIN  NULL,
  [update_by] nvarchar(50) COLLATE Latin1_General_BIN  NULL,
  [menu_remark] nvarchar(500) COLLATE Latin1_General_BIN  NULL
)
GO

ALTER TABLE [dbo].[tb_fe_menu] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Id',
'SCHEMA', N'dbo',
'TABLE', N'tb_fe_menu',
'COLUMN', N'menu_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Type',
'SCHEMA', N'dbo',
'TABLE', N'tb_fe_menu',
'COLUMN', N'menu_type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Name English',
'SCHEMA', N'dbo',
'TABLE', N'tb_fe_menu',
'COLUMN', N'menu_name_en'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Name Chinese',
'SCHEMA', N'dbo',
'TABLE', N'tb_fe_menu',
'COLUMN', N'menu_name_zh'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Parent ID',
'SCHEMA', N'dbo',
'TABLE', N'tb_fe_menu',
'COLUMN', N'menu_parent_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Display Order',
'SCHEMA', N'dbo',
'TABLE', N'tb_fe_menu',
'COLUMN', N'menu_display_order'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Rate',
'SCHEMA', N'dbo',
'TABLE', N'tb_fe_menu',
'COLUMN', N'menu_rate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Status',
'SCHEMA', N'dbo',
'TABLE', N'tb_fe_menu',
'COLUMN', N'menu_status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Delete Flag',
'SCHEMA', N'dbo',
'TABLE', N'tb_fe_menu',
'COLUMN', N'menu_deleted'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Create Time',
'SCHEMA', N'dbo',
'TABLE', N'tb_fe_menu',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Update Time',
'SCHEMA', N'dbo',
'TABLE', N'tb_fe_menu',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Creator',
'SCHEMA', N'dbo',
'TABLE', N'tb_fe_menu',
'COLUMN', N'create_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Updator',
'SCHEMA', N'dbo',
'TABLE', N'tb_fe_menu',
'COLUMN', N'update_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Remark',
'SCHEMA', N'dbo',
'TABLE', N'tb_fe_menu',
'COLUMN', N'menu_remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Factory Evaluation Menu Item',
'SCHEMA', N'dbo',
'TABLE', N'tb_fe_menu'
GO


-- ----------------------------
-- Records of tb_fe_menu
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tb_fe_menu] ON
GO

SET IDENTITY_INSERT [dbo].[tb_fe_menu] OFF
GO


-- ----------------------------
-- Table structure for tb_fe_test2
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_fe_test2]') AND type IN ('U'))
	DROP TABLE [dbo].[tb_fe_test2]
GO

CREATE TABLE [dbo].[tb_fe_test2] (
  [id] int  NOT NULL,
  [name] varchar(255) COLLATE Latin1_General_BIN  NULL,
  [age] int  NULL
)
GO

ALTER TABLE [dbo].[tb_fe_test2] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of tb_fe_test2
-- ----------------------------

-- ----------------------------
-- Table structure for tb_femenu
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_femenu]') AND type IN ('U'))
	DROP TABLE [dbo].[tb_femenu]
GO

CREATE TABLE [dbo].[tb_femenu] (
  [menu_id] int  IDENTITY(1,1) NOT NULL,
  [menu_type] int  NOT NULL,
  [menu_name_en] nvarchar(300) COLLATE Latin1_General_BIN  NOT NULL,
  [menu_name_zh] nvarchar(300) COLLATE Latin1_General_BIN  NOT NULL,
  [menu_parent_id] int  NOT NULL,
  [menu_display_order] int  NOT NULL,
  [menu_rate] int  NULL,
  [menu_status] int DEFAULT ((1)) NOT NULL,
  [menu_deleted] int DEFAULT ((0)) NOT NULL,
  [create_time] datetime DEFAULT (getdate()) NULL,
  [update_time] datetime  NULL,
  [create_by] nvarchar(50) COLLATE Latin1_General_BIN  NULL,
  [update_by] nvarchar(50) COLLATE Latin1_General_BIN  NULL,
  [menu_remark] nvarchar(500) COLLATE Latin1_General_BIN  NULL
)
GO

ALTER TABLE [dbo].[tb_femenu] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Id',
'SCHEMA', N'dbo',
'TABLE', N'tb_femenu',
'COLUMN', N'menu_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Type',
'SCHEMA', N'dbo',
'TABLE', N'tb_femenu',
'COLUMN', N'menu_type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Name English',
'SCHEMA', N'dbo',
'TABLE', N'tb_femenu',
'COLUMN', N'menu_name_en'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Name Chinese',
'SCHEMA', N'dbo',
'TABLE', N'tb_femenu',
'COLUMN', N'menu_name_zh'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Parent Id',
'SCHEMA', N'dbo',
'TABLE', N'tb_femenu',
'COLUMN', N'menu_parent_id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Display Order',
'SCHEMA', N'dbo',
'TABLE', N'tb_femenu',
'COLUMN', N'menu_display_order'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Rate',
'SCHEMA', N'dbo',
'TABLE', N'tb_femenu',
'COLUMN', N'menu_rate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Status',
'SCHEMA', N'dbo',
'TABLE', N'tb_femenu',
'COLUMN', N'menu_status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Deleted',
'SCHEMA', N'dbo',
'TABLE', N'tb_femenu',
'COLUMN', N'menu_deleted'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Create Time',
'SCHEMA', N'dbo',
'TABLE', N'tb_femenu',
'COLUMN', N'create_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Update Time',
'SCHEMA', N'dbo',
'TABLE', N'tb_femenu',
'COLUMN', N'update_time'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Create By',
'SCHEMA', N'dbo',
'TABLE', N'tb_femenu',
'COLUMN', N'create_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Update By',
'SCHEMA', N'dbo',
'TABLE', N'tb_femenu',
'COLUMN', N'update_by'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Menu Remark',
'SCHEMA', N'dbo',
'TABLE', N'tb_femenu',
'COLUMN', N'menu_remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Factory Evaluation Menu',
'SCHEMA', N'dbo',
'TABLE', N'tb_femenu'
GO


-- ----------------------------
-- Records of tb_femenu
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tb_femenu] ON
GO

INSERT INTO [dbo].[tb_femenu] ([menu_id], [menu_type], [menu_name_en], [menu_name_zh], [menu_parent_id], [menu_display_order], [menu_rate], [menu_status], [menu_deleted], [create_time], [update_time], [create_by], [update_by], [menu_remark]) VALUES (N'1', N'0', N'QAQC system', N'QAQC 系统', N'0', N'1', NULL, N'1', N'0', N'2024-08-28 17:19:40.090', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[tb_femenu] ([menu_id], [menu_type], [menu_name_en], [menu_name_zh], [menu_parent_id], [menu_display_order], [menu_rate], [menu_status], [menu_deleted], [create_time], [update_time], [create_by], [update_by], [menu_remark]) VALUES (N'2', N'1', N'Has factory set up independent QA/QC team?', N'工厂有否成立了独立的QA/QC团队？', N'1', N'1', NULL, N'1', N'0', N'2024-08-28 17:21:20.833', NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[tb_femenu] ([menu_id], [menu_type], [menu_name_en], [menu_name_zh], [menu_parent_id], [menu_display_order], [menu_rate], [menu_status], [menu_deleted], [create_time], [update_time], [create_by], [update_by], [menu_remark]) VALUES (N'3', N'2', N'All QA/QC team in All sections is not reported to The production', N'所有部门的所有QA/QC团队不向生产部汇报.', N'2', N'1', N'4', N'1', N'0', N'2024-08-28 17:47:10.040', NULL, NULL, NULL, NULL)
GO

SET IDENTITY_INSERT [dbo].[tb_femenu] OFF
GO


-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tb_user]') AND type IN ('U'))
	DROP TABLE [dbo].[tb_user]
GO

CREATE TABLE [dbo].[tb_user] (
  [id] int  IDENTITY(1,1) NOT NULL,
  [name] varchar(255) COLLATE Latin1_General_BIN  NULL,
  [age] int  NULL
)
GO

ALTER TABLE [dbo].[tb_user] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'user id',
'SCHEMA', N'dbo',
'TABLE', N'tb_user',
'COLUMN', N'id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'user name',
'SCHEMA', N'dbo',
'TABLE', N'tb_user',
'COLUMN', N'name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'user age',
'SCHEMA', N'dbo',
'TABLE', N'tb_user',
'COLUMN', N'age'
GO

EXEC sp_addextendedproperty
'MS_Description', N'table test',
'SCHEMA', N'dbo',
'TABLE', N'tb_user'
GO


-- ----------------------------
-- Records of tb_user
-- ----------------------------
SET IDENTITY_INSERT [dbo].[tb_user] ON
GO

SET IDENTITY_INSERT [dbo].[tb_user] OFF
GO


-- ----------------------------
-- Auto increment value for gen_table
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[gen_table]', RESEED, 7)
GO


-- ----------------------------
-- Primary Key structure for table gen_table
-- ----------------------------
ALTER TABLE [dbo].[gen_table] ADD CONSTRAINT [PK_gen_table_table_id] PRIMARY KEY CLUSTERED ([table_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for gen_table_column
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[gen_table_column]', RESEED, 41)
GO


-- ----------------------------
-- Primary Key structure for table gen_table_column
-- ----------------------------
ALTER TABLE [dbo].[gen_table_column] ADD CONSTRAINT [PK_gen_table_column_column_id] PRIMARY KEY CLUSTERED ([column_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table qrtz_blob_triggers
-- ----------------------------
ALTER TABLE [dbo].[qrtz_blob_triggers] ADD CONSTRAINT [PK_qrtz_blob_triggers_sched_name] PRIMARY KEY CLUSTERED ([sched_name], [trigger_name], [trigger_group])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table qrtz_calendars
-- ----------------------------
ALTER TABLE [dbo].[qrtz_calendars] ADD CONSTRAINT [PK_qrtz_calendars_sched_name] PRIMARY KEY CLUSTERED ([sched_name], [calendar_name])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table qrtz_cron_triggers
-- ----------------------------
ALTER TABLE [dbo].[qrtz_cron_triggers] ADD CONSTRAINT [PK_qrtz_cron_triggers_sched_name] PRIMARY KEY CLUSTERED ([sched_name], [trigger_name], [trigger_group])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table qrtz_fired_triggers
-- ----------------------------
ALTER TABLE [dbo].[qrtz_fired_triggers] ADD CONSTRAINT [PK_qrtz_fired_triggers_sched_name] PRIMARY KEY CLUSTERED ([sched_name], [entry_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table qrtz_job_details
-- ----------------------------
ALTER TABLE [dbo].[qrtz_job_details] ADD CONSTRAINT [PK_qrtz_job_details_sched_name] PRIMARY KEY CLUSTERED ([sched_name], [job_name], [job_group])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table qrtz_locks
-- ----------------------------
ALTER TABLE [dbo].[qrtz_locks] ADD CONSTRAINT [PK_qrtz_locks_sched_name] PRIMARY KEY CLUSTERED ([sched_name], [lock_name])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table qrtz_paused_trigger_grps
-- ----------------------------
ALTER TABLE [dbo].[qrtz_paused_trigger_grps] ADD CONSTRAINT [PK_qrtz_paused_trigger_grps_sched_name] PRIMARY KEY CLUSTERED ([sched_name], [trigger_group])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table qrtz_scheduler_state
-- ----------------------------
ALTER TABLE [dbo].[qrtz_scheduler_state] ADD CONSTRAINT [PK_qrtz_scheduler_state_sched_name] PRIMARY KEY CLUSTERED ([sched_name], [instance_name])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table qrtz_simple_triggers
-- ----------------------------
ALTER TABLE [dbo].[qrtz_simple_triggers] ADD CONSTRAINT [PK_qrtz_simple_triggers_sched_name] PRIMARY KEY CLUSTERED ([sched_name], [trigger_name], [trigger_group])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table qrtz_simprop_triggers
-- ----------------------------
ALTER TABLE [dbo].[qrtz_simprop_triggers] ADD CONSTRAINT [PK_qrtz_simprop_triggers_sched_name] PRIMARY KEY CLUSTERED ([sched_name], [trigger_name], [trigger_group])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Indexes structure for table qrtz_triggers
-- ----------------------------
CREATE NONCLUSTERED INDEX [sched_name]
ON [dbo].[qrtz_triggers] (
  [sched_name] ASC,
  [job_name] ASC,
  [job_group] ASC
)
GO


-- ----------------------------
-- Primary Key structure for table qrtz_triggers
-- ----------------------------
ALTER TABLE [dbo].[qrtz_triggers] ADD CONSTRAINT [PK_qrtz_triggers_sched_name] PRIMARY KEY CLUSTERED ([sched_name], [trigger_name], [trigger_group])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_config
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_config]', RESEED, 7)
GO


-- ----------------------------
-- Primary Key structure for table sys_config
-- ----------------------------
ALTER TABLE [dbo].[sys_config] ADD CONSTRAINT [PK_sys_config_config_id] PRIMARY KEY CLUSTERED ([config_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_dept
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_dept]', RESEED, 110)
GO


-- ----------------------------
-- Primary Key structure for table sys_dept
-- ----------------------------
ALTER TABLE [dbo].[sys_dept] ADD CONSTRAINT [PK_sys_dept_dept_id] PRIMARY KEY CLUSTERED ([dept_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_dict_data
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_dict_data]', RESEED, 34)
GO


-- ----------------------------
-- Primary Key structure for table sys_dict_data
-- ----------------------------
ALTER TABLE [dbo].[sys_dict_data] ADD CONSTRAINT [PK_sys_dict_data_dict_code] PRIMARY KEY CLUSTERED ([dict_code])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_dict_type
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_dict_type]', RESEED, 12)
GO


-- ----------------------------
-- Uniques structure for table sys_dict_type
-- ----------------------------
ALTER TABLE [dbo].[sys_dict_type] ADD CONSTRAINT [sys_dict_type$dict_type] UNIQUE NONCLUSTERED ([dict_type] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_dict_type
-- ----------------------------
ALTER TABLE [dbo].[sys_dict_type] ADD CONSTRAINT [PK_sys_dict_type_dict_id] PRIMARY KEY CLUSTERED ([dict_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_job
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_job]', RESEED, 4)
GO


-- ----------------------------
-- Primary Key structure for table sys_job
-- ----------------------------
ALTER TABLE [dbo].[sys_job] ADD CONSTRAINT [PK_sys_job_job_id] PRIMARY KEY CLUSTERED ([job_id], [job_name], [job_group])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_job_log
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_job_log]', RESEED, 1)
GO


-- ----------------------------
-- Primary Key structure for table sys_job_log
-- ----------------------------
ALTER TABLE [dbo].[sys_job_log] ADD CONSTRAINT [PK_sys_job_log_job_log_id] PRIMARY KEY CLUSTERED ([job_log_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_logininfor
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_logininfor]', RESEED, 123)
GO


-- ----------------------------
-- Indexes structure for table sys_logininfor
-- ----------------------------
CREATE NONCLUSTERED INDEX [idx_sys_logininfor_lt]
ON [dbo].[sys_logininfor] (
  [login_time] ASC
)
GO

CREATE NONCLUSTERED INDEX [idx_sys_logininfor_s]
ON [dbo].[sys_logininfor] (
  [status] ASC
)
GO


-- ----------------------------
-- Primary Key structure for table sys_logininfor
-- ----------------------------
ALTER TABLE [dbo].[sys_logininfor] ADD CONSTRAINT [PK_sys_logininfor_info_id] PRIMARY KEY CLUSTERED ([info_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_menu
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_menu]', RESEED, 1069)
GO


-- ----------------------------
-- Primary Key structure for table sys_menu
-- ----------------------------
ALTER TABLE [dbo].[sys_menu] ADD CONSTRAINT [PK__sys_menu__4CA0FADC4CAC36E5] PRIMARY KEY CLUSTERED ([menu_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_notice
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_notice]', RESEED, 3)
GO


-- ----------------------------
-- Primary Key structure for table sys_notice
-- ----------------------------
ALTER TABLE [dbo].[sys_notice] ADD CONSTRAINT [PK_sys_notice_notice_id] PRIMARY KEY CLUSTERED ([notice_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_oper_log
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_oper_log]', RESEED, 58)
GO


-- ----------------------------
-- Indexes structure for table sys_oper_log
-- ----------------------------
CREATE NONCLUSTERED INDEX [idx_sys_oper_log_bt]
ON [dbo].[sys_oper_log] (
  [business_type] ASC
)
GO

CREATE NONCLUSTERED INDEX [idx_sys_oper_log_ot]
ON [dbo].[sys_oper_log] (
  [oper_time] ASC
)
GO

CREATE NONCLUSTERED INDEX [idx_sys_oper_log_s]
ON [dbo].[sys_oper_log] (
  [status] ASC
)
GO


-- ----------------------------
-- Primary Key structure for table sys_oper_log
-- ----------------------------
ALTER TABLE [dbo].[sys_oper_log] ADD CONSTRAINT [PK_sys_oper_log_oper_id] PRIMARY KEY CLUSTERED ([oper_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_post
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_post]', RESEED, 5)
GO


-- ----------------------------
-- Primary Key structure for table sys_post
-- ----------------------------
ALTER TABLE [dbo].[sys_post] ADD CONSTRAINT [PK_sys_post_post_id] PRIMARY KEY CLUSTERED ([post_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_role
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_role]', RESEED, 3)
GO


-- ----------------------------
-- Primary Key structure for table sys_role
-- ----------------------------
ALTER TABLE [dbo].[sys_role] ADD CONSTRAINT [PK_sys_role_role_id] PRIMARY KEY CLUSTERED ([role_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_role_dept
-- ----------------------------
ALTER TABLE [dbo].[sys_role_dept] ADD CONSTRAINT [PK_sys_role_dept_role_id] PRIMARY KEY CLUSTERED ([role_id], [dept_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_role_menu
-- ----------------------------
ALTER TABLE [dbo].[sys_role_menu] ADD CONSTRAINT [PK_sys_role_menu_role_id] PRIMARY KEY CLUSTERED ([role_id], [menu_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for sys_user
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[sys_user]', RESEED, 3)
GO


-- ----------------------------
-- Primary Key structure for table sys_user
-- ----------------------------
ALTER TABLE [dbo].[sys_user] ADD CONSTRAINT [PK_sys_user_user_id] PRIMARY KEY CLUSTERED ([user_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_user_post
-- ----------------------------
ALTER TABLE [dbo].[sys_user_post] ADD CONSTRAINT [PK_sys_user_post_user_id] PRIMARY KEY CLUSTERED ([user_id], [post_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table sys_user_role
-- ----------------------------
ALTER TABLE [dbo].[sys_user_role] ADD CONSTRAINT [PK_sys_user_role_user_id] PRIMARY KEY CLUSTERED ([user_id], [role_id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for tb_fe_menu
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[tb_fe_menu]', RESEED, 1)
GO


-- ----------------------------
-- Primary Key structure for table tb_fe_test2
-- ----------------------------
ALTER TABLE [dbo].[tb_fe_test2] ADD CONSTRAINT [PK__tb_fe_te__3213E83FF62B9F1B] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for tb_femenu
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[tb_femenu]', RESEED, 3)
GO


-- ----------------------------
-- Auto increment value for tb_user
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[tb_user]', RESEED, 1)
GO


-- ----------------------------
-- Primary Key structure for table tb_user
-- ----------------------------
ALTER TABLE [dbo].[tb_user] ADD CONSTRAINT [PK__tb_user__3213E83FA02739D6] PRIMARY KEY CLUSTERED ([id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Foreign Keys structure for table qrtz_blob_triggers
-- ----------------------------
ALTER TABLE [dbo].[qrtz_blob_triggers] ADD CONSTRAINT [qrtz_blob_triggers$qrtz_blob_triggers_ibfk_1] FOREIGN KEY ([sched_name], [trigger_name], [trigger_group]) REFERENCES [dbo].[qrtz_triggers] ([sched_name], [trigger_name], [trigger_group]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO


-- ----------------------------
-- Foreign Keys structure for table qrtz_cron_triggers
-- ----------------------------
ALTER TABLE [dbo].[qrtz_cron_triggers] ADD CONSTRAINT [qrtz_cron_triggers$qrtz_cron_triggers_ibfk_1] FOREIGN KEY ([sched_name], [trigger_name], [trigger_group]) REFERENCES [dbo].[qrtz_triggers] ([sched_name], [trigger_name], [trigger_group]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO


-- ----------------------------
-- Foreign Keys structure for table qrtz_simple_triggers
-- ----------------------------
ALTER TABLE [dbo].[qrtz_simple_triggers] ADD CONSTRAINT [qrtz_simple_triggers$qrtz_simple_triggers_ibfk_1] FOREIGN KEY ([sched_name], [trigger_name], [trigger_group]) REFERENCES [dbo].[qrtz_triggers] ([sched_name], [trigger_name], [trigger_group]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO


-- ----------------------------
-- Foreign Keys structure for table qrtz_simprop_triggers
-- ----------------------------
ALTER TABLE [dbo].[qrtz_simprop_triggers] ADD CONSTRAINT [qrtz_simprop_triggers$qrtz_simprop_triggers_ibfk_1] FOREIGN KEY ([sched_name], [trigger_name], [trigger_group]) REFERENCES [dbo].[qrtz_triggers] ([sched_name], [trigger_name], [trigger_group]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO


-- ----------------------------
-- Foreign Keys structure for table qrtz_triggers
-- ----------------------------
ALTER TABLE [dbo].[qrtz_triggers] ADD CONSTRAINT [qrtz_triggers$qrtz_triggers_ibfk_1] FOREIGN KEY ([sched_name], [job_name], [job_group]) REFERENCES [dbo].[qrtz_job_details] ([sched_name], [job_name], [job_group]) ON DELETE NO ACTION ON UPDATE NO ACTION
GO

